cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Filters don't work on an OLAP SSAS Parent dimension

We have an OLAP SSAS cube with an Usage->Parent dimension.

 

Dimension data includes

- Key

- Parent

- Name

 

Data is structured at three levels where Parent points to the Key of its parent.

Key is defined with NameColumn->Name

 

So the users see

 

GrandFatherName ..... FatherName ..... SonName ....................... SonData

 

But we cannot make any filter to work on PowerBi.

When a GrandFatherName is selected, no data is displayed

When FatherName is selected, no data is displayed

When SonName is selected .... well, this is still more unusual, there is no SonName list, we get a list of <blank> values! so we don't know which Son are we selecting, but nevertheless, again no data is displayed.

 

Accessing the cube using Excel and a pivot table works as expected, any level of data can be explored and selected.

 

Any idea what can be wrong?

10 REPLIES 10

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors