If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Need to get the mun value from a member

Started by manu2105, 22 Aug 2024 12:08:22 PM

Previous topic - Next topic

manu2105

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.

cognostechie

How can the current business day be stored in a measure?

MFGF

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.
Meep!

manu2105

businesskey is the one I used, if i use caption , can i then typcast string to number to compare ?

manu2105

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.