Stack Overflow
Stack Overflow

Questions tagged [multidimensional-cube]

59 questions
0
votes
1 answer

Can I connect SQL Server Analysis Services (SSAS) to Azure Data Factory (ADF)

I would like to connect my SSAS multi-dimensional cube to Azure Data Factory. The purpose of this would be to copy the data from the Analysis Services cube to an Azure Storage Account. The cube contains calculated measures, otherwise, I could just…
Shoaib Maroof
  • 369
  • 1
  • 3
  • 13
0
votes
0 answers

SSAS Visual Studio Multi DImensional Modeling, calculated field returns infinite value

I have fact table which is about shipments. A shipment (FACT) contains a certain amount of containers. A ship (Dimension) contains a max amount of container (MaxTEU in my example). I want to calculate the LoadFactor which is nothing more then…
MisterQvD
  • 27
  • 6
0
votes
0 answers

Error from SQL Server stored procedure: "Neither the CommandText property nor the CommandStream property is set."

I'm adding code to a SQL Server procedure that takes a string input, parses it into an mdx query, executes the query and returns the results. I have created a function that parses the dates and measures in a way the procedure previously could not. I…
user8675309
  • 49
  • 6
0
votes
0 answers

How to replicate multidimensioanl cube dimension Unaryoperator in analysis services Tabular model

I am migrating a multidimensional model to a tabular model. Some of the dimensions are using unaryoperators property in their columns. Can someone please guide me how to replicate the unaryoperator feature in the analysis services tabular…
Arif
  • 377
  • 2
  • 5
  • 21
0
votes
1 answer

I need an MDX query that operates like a Group by Statement

I need an MDX query that is able to aggregate a Fiscal Year while only pulling parts of a year. Let's say the client wants to see sales for a fiscal year but the given date range is 20210601 - 20230303. As of now if I try to ask for sales crossed…
user8675309
  • 49
  • 6
0
votes
0 answers

Exporting / Sharing SSAS project from Visual Studio 2019

I'm trying to figure out how could I share my multidimensional cube or what setting should be set at the beggining so that I could export and share my solution to other PC. I struggle to find answer and still not quite sure how to do that. Is it…
niknoy nori
  • 31
  • 3
0
votes
0 answers

HashMapping a cubic volume

I am trying to map a zero indexed value to a multidimensional array list using the map function so that I can assign data to specific values within the arraylist without having to constantly request that I Dex location. The code I have written is…
Russell Clarke
  • 21
  • 2
0
votes
0 answers

HFM Extract data to file is resulting in Parent Child error

I am trying to do a simple extract in HFM and I keep getting this error. "Parent-Child name must be specified for Entity dimension due to value: [Parent Total] Member found that requires parent name:" All the members in the extract are valid…
Ryan
  • 1
  • 1
0
votes
0 answers

Check and process a SSAS cube when it's not already processing

I have an application that is driven by a Microsoft Analysis Services Multidimensional Cube. Users access the application and load data periodically to the underlying SQL database. The cube is processed fully over night so users may see updated…
warrenk
  • 119
  • 1
  • 7
0
votes
1 answer

SSAS : Filter Cube

I have dimension and fact table. The dimension is PATIENTDBOID meanwhile the fact table is Total_Admissions. Now, I want to filter for Patient that Admission >1 Can someone help me how. ?
merry
  • 17
  • 7
0
votes
1 answer

Best solution for generating flat report

I have an SSAS multidimentional cube (sql server 2019) of 350 GB with a retention of 10 years of data. I noticed that users often use the cube to extract data at the leaf level (Excel tables with multiple columns). I think that SSAS is not suited…
SniperPro
  • 75
  • 1
  • 10
0
votes
1 answer

SSAS Tabular model refresh table structure automatically

I have an underlying code, which allows users to upload their CSV files and use the data as a dimension in our SSAS Tabular model. Every time a user uploads a file, the code adds a new column to this table with the name of its corresponding file…
Paniz Asghari
  • 145
  • 1
  • 10
0
votes
1 answer

what are the pre-requisites and practices for multidimensional cube Designing ( during analysis phase)?

I'm assigned to design multidimensional cube in SSAS. As I am very new to SSAS, and currently this is in analysis phase. Just wanted to see , is there any standard process or guideline should I follow or any general questions should I prepare prior…
Ali
  • 91
  • 1
  • 8
0
votes
1 answer

Regenerate SSAS multidimentional partitions files from the database

I have an ssas cube and I want to create the solution with ssdt on visual studio. I need to generate the .partations file of the cube. When I do New Project -> Import from server (multidimentional and data mining) The project is created but the…
SniperPro
  • 75
  • 1
  • 10
0
votes
1 answer

MDX Calculated Member Performance Issue

SELECT NON EMPTY { [Measures].[Production_Volume] } ON COLUMNS, NON EMPTY { ( [Make].[Make ID].[Make ID].ALLMEMBERS * [Model].[Model Hierarchy].[MDL].ALLMEMBERS * [Customer].[Customer ID].[Customer ID].ALLMEMBERS ) } ON ROWS FROM…
Arjun
  • 1,049
  • 6
  • 23
  • 37
1 2
3
4