Crosstab Report

[srinu1253]

                                          Weekly No
              Previous Year   Current Year    Difference
Organization.Organization   Call Count   X   X   X
                             Call Cost                X   X   X


This is the Crosstab Report Layout. I have a Prompt page with date prompt. When I select date for exp 15 Oct 2010.


The output should be as below.


                                                       41
                                         2009   2010      Dif    Organization.Organization   Call Count   15   10           5
                             Call Cost             1500   1000   500

When I am working on this report I am getting Same values for 2009 and 2010.Can you please suggest any approach.

Organization is a Dimension here.
Call Count and Call Cost are facts. Week No is in Date dimension.

Note:- the column headers should chage dynamically a per the date Prompt.
i.e. if the date prompt value selected  is Oct 15 2009 then the output should be....

                                                       41
                                         2008   2009      Dif    Organization.Organization   Call Count   15   10           5
                             Call Cost             1500   1000   500

Can any one suggest this scienerio...

[rockytopmark]

Sounds to me like you are aggregating within the measures' expressions.  Try removing the aggregate functions from the expressions and set them on the Data Item properties.

[srinu1253]

hi ,
thanks for the reply.Is there any way to get the column headers dynamically if I select oct 15 2010 then

Week No should be 42
Previous Year 2009
Current Year 2010

for this report..

[Sreeni P]

hi ,
thanks for the reply.Is there any way to get the column headers dynamically if I select oct 15 2010 then

Week No should be 42
Previous Year 2009
Current Year 2010

for this report..

For the above evaluation we have lot of options to display column headers dynamically using business/date functions .

for current year: extract ([date dimension],year)
for previous year:_add_years(extract(date dimension),year),-1)
Week No: _week_of_year([date dimension])


Regards,
Palutla,

[srinu1253]

Hi Srinivas,

I am using Cube as a source for the packege.I am finding it difficult for displaying Years & Weekno dynamically and data needs to be changed dynamically as there is only one date prompt can you suggest any approach and do we need to use any MDX functions here?

[arunkr109]

                                          Weekly No
              Previous Year   Current Year    Difference
Organization.Organization   Call Count   X   X   X
                             Call Cost                X   X   X


This is the Crosstab Report Layout. I have a Prompt page with date prompt. When I select date for exp 15 Oct 2010.


The output should be as below.


                                                       41
                                         2009   2010      Dif    Organization.Organization   Call Count   15   10           5
                             Call Cost             1500   1000   500

When I am working on this report I am getting Same values for 2009 and 2010.Can you please suggest any approach.

Organization is a Dimension here.
Call Count and Call Cost are facts. Week No is in Date dimension.

Note:- the column headers should chage dynamically a per the date Prompt.
i.e. if the date prompt value selected  is Oct 15 2009 then the output should be....

                                                       41
                                         2008   2009      Dif    Organization.Organization   Call Count   15   10           5
                             Call Cost             1500   1000   500

Can any one suggest this scienerio...

[rockytopmark]

you absolutely need to use "MDX' functions since you are using a Cube!!

Ancestor([your selected date member],[Year level]) ...will get you your selection's current year

...and something like:
lag(Ancestor([your selected date member],[Year level]),-1) would give you the prior year value.

Using these functions can take some trial and error to get right... just work with them and your comfort in using them will set in.

HTH, M