Skip to main content
Stack Overflow
  1. About
  3. For Teams
Filter by
Sorted by
Tagged with
0 votes
0 answers
39 views

I'm converting a multidimensional cube to tabular. As it happens, I have several many-to-many relationships between my dimensions and measures group, as you can see in the image below. I've searched ...
0 votes
0 answers
34 views

I'm doing a BI school project in which I had to collect and clean data to create a multidimensional model. I selected yearly crime data by districts of my country and enriched it with demographics and ...
0 votes
1 answer
533 views

I'm trying to switch the sql server analysis services to multidimensional since I'm getting an error in visual studio when I try to deploy my analysis project that says I can't deploy the model ...
0 votes
1 answer
83 views

Lastyear I had to migrate a cube to MS SSAS for a fixed dataset of two days, T1 and T2 and they have an epoch of 'SOD' (for Start of Day). Now I am drip-feeding real-time data into the cube with ...
0 votes
1 answer
114 views

Can anyone explain what is the difference in using filter() and Where in MDX queries? I am trying to create MDX queries using the OLAP4j query model and I am confused as to when to use filter() and ...
0 votes
0 answers
90 views

I have a Microsoft Multi-Dimensional OLAP cube that needs to have partitions created and processed. I know how to generate the scripts, but Im not sure how to execute each statement consecutively. Id ...
0 votes
0 answers
42 views

Context: 1 role authorize all facts data with a filter in Dimension Data on a society Need: Some members in the first role need access to some facts (but not authorize on all facts) in other society I ...
0 votes
1 answer
138 views

I have a SSAS cube where I am trying to calculate the percent total of a sales measure against a Location Hierarchy. The location hierarchy has two members from Top to Bottom: State/Province > City....
0 votes
0 answers
65 views

I am using an MDX query in Power BI to extract data from SQL Server Analysis Services, but for some reason the query is repeating every column twice. I don't have the knowledge of MDX query, so I used ...
0 votes
0 answers
277 views

I have a SQL Server 2016 OLAP Cube in the multidimensional mode and a corresponding database containing the tables Cases and Person. The Case table has the columns StartDate and EndDate and the Person ...
2 votes
1 answer
147 views

I have a MutliDimensional Cube, it has a Dimension(Hierarchy) named "Scenario", within the Scenario dimension I have a "SA - Scenario" level which refers to a DimensionAttribute &...
0 votes
1 answer
3k views

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 ...
0 votes
0 answers
65 views

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 ...
0 votes
1 answer
565 views

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 - ...
1 vote
2 answers
43 views

I have 3 measures: A, B, C Measure c is this calculation: IF(A>B) THEN A-B ELSE 0 This formula run for every records, which works fine. The problem is that. I want to get sum of the measure c, ...

15 30 50 per page
1
2 3 4

AltStyle によって変換されたページ (->オリジナル) /