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

 

How to display the value of previous level after drilling down

Started by cognostechie, 09 Feb 2007 01:06:09 PM

Previous topic - Next topic

cognostechie

This works in Analysis studio by itself. When I open the cube and drill down, the information of the previous level (the higher level) is displayed as a summary. Pretty common thing..right? So taking the Great Outdoors as an example:

When I drill down from 'Camping Equipment' , it shows 'Cooking Gear, Tents etc' and their revenue AND it also shows the value of 'Camping Equipment' (because that's where it came from). Now here's the problem. How to do that in Report Studio?? The standard way to do this is to add a Summary and define it as 'Total, average, standard deviation etc'. Well, I don't need the total because in my case, the values of lower level are NOT additive to determine the values of higher level.

I could have 2 categories at the lower level and the values could be 200 & 300 but the values of the higher level could be 400. My cube is working fine when I open in Analysis studio but is there a way to get this in Report Studio?

Any help will be much appreciated.

Regards,

MDXpressor

One hope you may have is to populate your rows with a Level (like Product Line in the Great Outdoors Company), then nest below it, the single level higher (in this case Products).  As you drill down on Product Line, so to will Products.  Having said that, this runs into problems when you drill down to the bottom of the heirarchy.  At the bottom of the heirarchy you will only see the Products level from 2 levels higher.

Have a look at the attached crosstab.  When you drill down on the Product Line level, Products will come down with you.  If you drill on the Order Method1, since Order Method1 is already at the bottom of the heirarchy Order Method stays 2 levels above.

Are your levels aggregatable at all? i.e. maybe not with total, but some other form of aggregate.
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien

cognostechie

Thanks for your efforts MDXpressor. This site does not allow me to download your attachment  ???

Anyway, the levels are not agregatable at all.  There is no rule for that and it could be anything at any level. I would also need the value of the previous level at every level all the way till the bottom.

Thanks though,

benjaaz

Select the crosstab and then checkout the "drill behaviour" in the "Data" menu item.  On the "Advanced" tab you can select an item and do the "ancestor" attribute and put a "1" in the levels back. I created a duplicate item like "product line" and called it something else and used this ancestor method. When I drill down on product line once it drills down the rows show what product line drilled to but my duplicate item showed 1 level up because of the ancestor method.  Hope I explained it correctly.  There's some documentation somewhere on the Cognos site.