Back

Explore Courses Blog Tutorials Interview Questions

Unknown member in referenced relationship in ssas eliminate in mdx query

0 votes
2 views
in BI by (120 points)
In SSAS I have a fact that have a referenced relationship with a dimension(A) then my fact have indirect relationship with another dimension(B).

In MDX I have a measure of my fact and dimension B in Row. when I execute, the answer is only member that have value. Unknown member is ignored.

I need to know measure value for Unknown member. how can get it ?

Please log in or register to answer this question.

Related questions

0 votes
1 answer
MDX to SSAS calculation
asked Feb 27, 2020 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
MDX query in Tableau pivot table
asked Dec 29, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
Can I run my own DAX or MDX queries against Power BI? Ask
asked Jul 6, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
Cannot create measure or calculated column in Power BI
asked Jul 16, 2019 in BI by Vaibhav Ameta (17.6k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...