Multiple Measures into Same Crosstab Fact in Report Auth 10.2.1

[gosoccer]

Hi everyone,

I have a Crosstab and I have a need to drop two measures for the middle fact area of a Crosstab.

So, one section shows the data as of today and the other column of the Crosstab shows the
data as of last 6 months. Same Edges will be utilized but I'm trying to present two column of data
for every intersection.

Pls see the attached spreadsheet snapshot.

Could you be able to help?

Thx so much for your time.

[MFGF]

Hi everyone,

I have a Crosstab and I have a need to drop two measures for the middle fact area of a Crosstab.

So, one section shows the data as of today and the other column of the Crosstab shows the
data as of last 6 months. Same Edges will be utilized but I'm trying to present two column of data
for every intersection.

Pls see the attached spreadsheet snapshot.

Could you be able to help?

Thx so much for your time.

Dimensional or relational package?

MF.

[gosoccer]

DMR package so it's Dimensional but not OLAP (CUBES)

[MFGF]

DMR package so it's Dimensional but not OLAP (CUBES)

DMR makes it fairly easy :)

The Today column could be a calculation with an expression such as:

tuple([Your measure], closingPeriod([date level from your time dimension]))
This assumes the last date member in the time dimension is today. If not, we'd need to see the MUN of one of your date members to figure out how to pinpoint the member for today.

The 6 Months column could be a calculation with this expression:

aggregate([Your measure] within set lastPeriods(6, closingPeriod([Month level from your time dimension])))
Again, this assumes this month is the last member in the month level in your time dimension. If not, we'd need to see the MUN of a month member...

Cheers!

MF.

[gosoccer]

Excellent. Thx so much.

I actually end up handling it as Framework Manager level. So, one calculation within Subject Query for regular
rows to be returned and a separate calculation for retrieving the last 6 months records.

At the Crosstab, just created the empty crosstab cell (with fact data) and dropped the 6 months measure into the
cell and it is working beautifully.

Thx so much.