Weekly and Quarter

[Prakash Bhai]

Hi All, I have a radio button called weekly, when the user clicks on 'Weekly', all the weeks in the current quarter are displayed.
However the user should also be able to choose which quarter they wish to view (other than the current quarter) ie Q1, Q3 etc


Regards

Ram

[MFGF]

1. What kind of package are you using - relational or dimensional?

2. What expression is used to identify the current quarter in the report?

3. What expression is used to drive the current "weekly" prompt?

MF.

[Prakash Bhai]

Hi MF,

1)I am using Dimensional Model.
2)To identify current quarter, we used cast(current_quarter)
3)We used a macro function for current week,

[MFGF]

Hi,

I'm not quite following how you have got this working currently.  The cast() function is used to change values from one data type to another, not to isolate members from a dimensional source.  I'm also not clear about how your weeks are being derived either - there are lots of macro functions, but I can't think of any that are designed to manipulate dimensions or members?

However, since you are using a dimensional package, the task should be fairly easy.

1. To get your current quarter, you can use a Query calculation with the following expression:  closingPeriod([your quarter level from the time dimension]).  You can then use the lag() function to bring in the prior quarter, or two quarters prior etc.  Alternatively, you could use an expression such as [your quarter level from the time dimension] -> ?Quarter? to generate a prompt for the desired quarter.

2. To bring in the weeks for the selected quarter, you can use the children() function for the quarter in question.

Regards,

MF.