Hi , I have a business day dimension in rows and it has numbers from 1 to 23 and I have a report shpwing certain sales, I need to check if current member is less than or equal to current business day then do something or not , my mun is
[Agency Sales - Daily].[Business Days].[All Business Days].[Business Days]->:[PC].[@MEMBER].[15] or
[Agency Sales - Daily].[Business Days].[All Business Days].[Business Days]->:[PC].[@MEMBER].[1]
so I need to get the current member and get the value as 15 or 1 and then check with current business day , I have my current business day stored in a measure and I am not sure how to get the value of 15 or 1 from the mun , rolevalue doesnot return anything .
Any help is appreciated.
How can the current business day be stored in a measure?
Quote from: manu2105 on 22 Aug 2024 12:08:22 PMHi , I have a business day dimension in rows and it has numbers from 1 to 23 and I have a report shpwing certain sales, I need to check if current member is less than or equal to current business day then do something or not , my mun is
[Agency Sales - Daily].[Business Days].[All Business Days].[Business Days]->:[PC].[@MEMBER].[15] or
[Agency Sales - Daily].[Business Days].[All Business Days].[Business Days]->:[PC].[@MEMBER].[1]
so I need to get the current member and get the value as 15 or 1 and then check with current business day , I have my current business day stored in a measure and I am not sure how to get the value of 15 or 1 from the mun , rolevalue doesnot return anything .
Any help is appreciated.
Hi,
You didn't specify which rolevalue attribute you were using? Have you tried using the caption() function for the member?
Cheers!
MF.
businesskey is the one I used, if i use caption , can i then typcast string to number to compare ?
Okay to explain , my dimension looks like All Business days with numbers from 1 to 23 .
In my crosstab I have Descendants([All Business Days],1) so it list numbers from 1 to 23 in the rows .
Now I need to add a column in crosstab which will do calculations only for the days until its current business days in the month .
The mun is [Agency Sales - Daily].[Business Days].[All Business Days].[Business Days]->:[PC].[@MEMBER].[4]
Now I am trying to have a query calculation where I would like to say
if(caption(currentMember(All Businessdays)='5') then (0) Else (1)
But this does not work it returns blank on all the rows.
Can someone guide the right way to check this so the data is calculated only for certain rows.