OLAP Report 10.1.2 Dimensional H. Percentage Calculation

[gosoccer]

If someone could please help me with this, I'll greatly appreciate it.

Everything looks good with the Crosstab but unfortunately, the percentages are
all showing as the same #. Please see attached.

The Crosstab node members are measures from cube.

Thx so much :(

[bdbits]

There is not nearly enough information supplied. At a minimum what is the expression for the percentages column?

[MFGF]

If someone could please help me with this, I'll greatly appreciate it.

Everything looks good with the Crosstab but unfortunately, the percentages are
all showing as the same #. Please see attached.

The Crosstab node members are measures from cube.

Thx so much :(

Ah. Yep. It's a problem with your expression. Almost certainly. Maybe. Perhaps.

MF.

[gosoccer]

Sorry about that. Here is the report spec.

[gosoccer]

 :(OK, I just compared to what the Crosstab is showing to what the cube is showing in Powerplay and it is not good.
I don't think I'm dragging the right edge and node to the Crosstab. The #s showing are much larger than what the cube
is showing for the last 30 days. PLS Help!!

[gosoccer]

This could be the issue. Would the following approach pull the last 30 days data?

I created a data item and named it as Macro and dropped it into the Slicer.

lastPeriods(30,#'[dsCube-is-rapids-0007-idcardrollup-prod].[Time].[Time].[Day]->:[PC].[@MEMBER].['+timestampMask($current_timestamp,'yyyymmdd')
+']'#)

I appreciate the help.
;D ::)

[gosoccer]

Anybody???

[MFGF]

This could be the issue. Would the following approach pull the last 30 days data?

I created a data item and named it as Macro and dropped it into the Slicer.
I appreciate the help.
;D ::)

What does the item resolve to? Is it the members you expect? Try removing it from the slicer and adding it to an edge to see what it delivers. Seems like a good way of debugging to me.

I don't have RS handy. What expression are you using for your percentage?

MF.

[MFGF]

Anybody???

Really? You waited a whole hour and seven minutes before posting this? Seems a pretty rude, selfish and pushy thing to do, doesn't it? Nobody on here gets paid to respond to your questions in your timescale. People have their own jobs and lives, and help out of the goodness of their own hearts. Why would you treat them this way?

MF.

[gosoccer]

Please accept my apologies! I very much respect this site and the people who provide support.

[gosoccer]

OK,

I tried your suggestion and it is sure a good way of reviewing the issue. Please see attached. showing the count difference between
the Powerplay and the actual report.

Thank you,

[MFGF]

OK,

I tried your suggestion and it is sure a good way of reviewing the issue. Please see attached. showing the count difference between
the Powerplay and the actual report.

Thank you,

Are these two reports showing the same data? The contents of the PowerPlay report look entirely different to the ones you have in your Report Studio report?

MF.

[gosoccer]

yes, one is a snapshot of the cube using Power Play and the other one is the actual report.
The powerplay one doesn't lie but the report from report author is lying.

I think on my report that I sent the Spec, OR the Query that goes after the last 30 days is not working correctly or the Crosstab, Edge, Columns, etc is not correct? If someone review my Spec and see if I am using the Crosstab correctly, I would greatly appreciate it since
the #s are way off.

The Report is using the same exact Cube that the Power Play is verifying the data.

Thanks

[gosoccer]

This could be the problem. Dropped in the Slicer as it shows in the report spec.

lastPeriods(30,#'[dsCube-is-rapids-0007-idcardrollup-prod].[Time].[Time].[Day]->:[PC].[@MEMBER].['+timestampMask($current_timestamp,'yyyymmdd')
+']'#) 

Or Edge or Node Member is not correct.

Thank you in advance for your time/

[MFGF]

Hi,

I managed to get the report spec loaded into Report Studio. The crosstab you have defined there looks nothing like the crosstab results you showed in your comparison image - that had two nested row headings and this report has no nesting in rows. I'm confused.

I looked at the queries and you have four queries in the report?

I think you need to simplify. Build the most basic crosstab you can - one query with the members you need. Then we can figure out what slicers you might need...

MF.

[gosoccer]

OK,

Made the report very simple. Just a small Crosstab. The counts are showing much higher than the cube shows
for the last 30 days. Would you please take a pick at the Crosstab and let me know if I have created it correctly.


Thx in advance,
:)

[srinu_anu2007]

Hi,

Try this preperty- solve order=2(for crosstab columns)