Stack Overflow
Stack Overflow

Questions tagged [multidimensional-cube]

59 questions
1
vote
0 answers

How to implement three-way clustering in python

I am relatively a learner in the field of datascience. Recently I came across these concepts and I am really keen to implement them - i.e. the concept of multimodal clustering applications. (From here I got the idea -…
K C
  • 413
  • 4
  • 15
1
vote
1 answer

Create N dimensional grid of points in JavaScript

I know there are similar questions out there (the closest one I found was this JavaScript; n-dimensional array creation) but most one them are in Python and even this one I found I tried to implement in my code and It didn't work. So I want to…
Daniel Guedes
  • 387
  • 1
  • 4
  • 14
1
vote
0 answers

SSAS Multidimensional: Query results change if I add one more attribute to dimension

I have a difficult time understanding why a simple MDX query returns different results if a dimension has an additional attribute which has KeyColumns same as KeyColumns of the key attribute. Here is an example Create a simple cube called…
Alex
  • 123
  • 2
  • 3
  • 9
1
vote
1 answer

cross join in facts and dimension

In the multidimensional cube, I have two facts (at different grain) named as : FactTestScore and Fact SubjectScore. These two facts share two dimensions- DimStudent and DimSubject. And FactTestScore has additional dimension of DimTest. I've deployed…
Nancy Drew
  • 31
  • 2
1
vote
1 answer

MDX Scope to get denominator

I have a SSAS multidimensional cube and i am trying to calculate a denominator for a query by using a scope statement. I am trying to assign the measure "Total SalesCumulative" the total value of all the sales for all the stores. I want this to stay…
Basil
  • 747
  • 7
  • 18
1
vote
1 answer

Get All Linked Members using LinkMember function

Please consider this structure: Fact: Sender Receiver Amount ---------------------------------------- Reseller1 Resseler2 100 Reseller1 Resseler3 200 Reseller3 Resseler1 150 Reseller3 …
Arian
  • 12,793
  • 66
  • 176
  • 300
1
vote
1 answer

How to make an attribute relationships and hierarchies when you have two or more attributes with the same key value but different name?

When making a date dimension in a SSAS multidimensional cube, it is simple to make a hierarchy and attribute relationships for day, month, quarter, and year, which all roll up into one another. But what if I have a couple of attributes that combine…
Kelly
  • 945
  • 2
  • 18
  • 31
1
vote
1 answer

How to fix: "Operation returned an invalid status code 'BadRequest’" when connecting PowerBI Embedded to an SSAS Multidimensional cube

I have an (on premise) SSAS (Multidimensional) cube with a live connection to Power BI. Then it has to be shown in a portal with Power BI Embedded. I used the method: 'App owns data' and with a 'master user' account. This part works. But when i try…
Jeffrey
  • 111
  • 1
  • 4
1
vote
1 answer

SSAS - Problem with summarizing in OLAP SSAS - diffenent than in database

I have one problem with my OLAP CUBE. Before it was ok, but recently in my database I add a new dimension. Off course I did another import and every data in database is ok. Then I built new OLAP CUBE with all (and a new) dimensions. I thought that…
Elwira Sochacka
  • 13
  • 3
0
votes
0 answers

SSAS Multidimensional - Access specific fact on specific dimensionnal

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 create a second role with dimension data filter…
Patrick Salvador
  • 1
  • 1
0
votes
1 answer

Getting percent total of group using MDX

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. Ex: State City ---------------------- Florida …
Cristian Navarrete
  • 1
  • 1
0
votes
0 answers

MDX query output producing the same column multiple times

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 report builder for this. The query: SELECT …
Jeevan
  • 19
  • 3
0
votes
0 answers

How to display data in an sql server olap cube by a given time dimension with a special filtering

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 table has the columns FirstName, LastName, and…
Steven2105
  • 540
  • 5
  • 20
0
votes
0 answers

SSAS cube process from Google big query using Cdata ADO.net driver

I have created a multidimensional cube from a data source located on Google BigQuery cloud database. To connect the SSAS cube to BigQuery, I have utilized the CData ADO.net provider for BigQuery. The cube I created is relatively simple, consisting…
Sagar Hinge
  • 1
  • 2
0
votes
0 answers

Are OLAP Cubes Self generating?

A month ago I was given a ticket to work on a SQL Server Olap cube that didn't have any data for March 2023. I discovered one of the issues was that the partitions in the cube were expired. I created new partitions, reprocessed, and all is good. Now…
user8675309
  • 49
  • 6
1
2
3 4