September 11, 2014 at 1:11 am
Hi,
I have 2 different dimensions and fact table,but i want amount based on 2 dimension Attribute filtration names.
Member [Measures].[Revenue_Budget_Amount]
AS Sum(
{([Finance Indicator].[Fin Indicator Desc].&[Budget] ,[Particulars].[Particulars].&[Revenue] )},
[Measures].[Amount_Value])
i wrote this query its not working filtration ,can u pls help me on this.
Regards,
Raghava.
September 11, 2014 at 2:27 am
Are both of your dimensions related to the fact in your Dimension Usage tab in SSDT/BIDS? How is it not filtering? What is the expected result? What is the result you are getting?
There's nothing syntactically wrong with your calculation so my guess is that you might not have dimension-fact relationships set up properly.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy