Drill down in a Dimensional Cube

[Cog_rookie]

Hi all, I am having problems with the drill down in a report studio. Report 1 contains the source report where it has 2 prompts and Report 2 is the target report report. I have tried passing drill down by MUN value but it does not seem to be working. Any response would be greatly appreciated. Thanks.

[tjohnson3050]

First, just to clarify terminology, drill down is when you click on a dimension in a report and navigate down a level in the hierarchy of that dimension within the same report.  When you click on a link in one report and that passes a value to a paramater in a second report, that is called drill through.

When you define a drill through, you map either data items, or parameter values to the parameters in the target report.  You need to make sure what you are going to pass matches the parameter in the target report.  For example, if the target report filter is looking for a MUN, you need to define MUN in the drill definition.

[Cog_rookie]

Hi tjohnson3050,

Thanks for your reply. Apologies for not explaining clearly I have a cube and this cube is built in such a way that reporting on it is harder than just building another cube.

I have 2 different hierarchies, in 1 source report there is total sales with 12 months and for the target report there are customers. So I need a drill through to each transaction when I clicked on the sale column.

I have passed the MUN values but when I click on the drill through it doesn't show any value.

Example Source report has Sales, Purhaces, Gross Profit in the rows and 12 months in the column. I have 2 prompts asking the user to select the year and version such as actual, forecast etc.
I have 3 detail filters in the target report corresponding to the source report but I have got one filter which selects the MUN and is supposed to pass the value but currently is not.

After the user has done their selection they should be able to go through the customers level such as which customer bought the product from us, so when the user clicks on the source report it goes on to the customer side. This means that the 2 report is based on completely different hierarchies source report is in a different hierarchy than the target report and each has different members.

I have read about slicers and am completely new to cube reporting so I do not know much about, so any help would be greatly appreciated.

Thanks.

[tjohnson3050]

Ok, so are your source and target reports based on two different cubes, or the same cube?

[Cog_rookie]

Although they are from the same cube, they are completely on different dimensions so is it possible to create a dynamic drill through rather than having to define the drill through each one by one with their MUN value, as I have got a very large columns.

[bdbits]

I am on 10.1.1 FP1 but what I am about to explain is similar going back to 8.3.

Instead of left-clicking on the source report link, right-click it and choose "go to related links". This should give you a list of valid targets (may be only one for you). Underneath that list on the right-hand side, click on "view passed source values". Also, on the target report name there should be a downward pointing chevron (double-arrow) that will give you additional information. Between the two displays you should be able to determine what is getting passed when you do the drill-through.

If you are at least reaching the target report without an error, another trick is to use the report functions to display what was passed, e.g. ParamValue(), ParamDisplayValue(), and maybe ParamNames().

Double-check the source report drill-through definition and the target. Make sure you've selected the appropriate parameters, especially regarding the "Type", "Method", and "Property to Pass". It is easy to mess this up, I've done it plenty of times. :-)

The only other thing I noted is that you say the reports are on the same cube but "completely different dimensions". It sounds to me like you at least want to filter the target report by the date in context for the source link being clicked on. You certainly need at least one dimension in common, otherwise what are you drilling through to? It would make no sense without _something_ in common.

Hope this information helps.

[Cog_rookie]

hi bdbits,
could you please give me more detail as to locate the mentioned detail "Instead of left-clicking on the source report link, right-click it and choose "go to related links" " .
I am on cognos 10.1

[bdbits]

Normally you click a link to drill-through. Just right-click the link and you'll get a popup context menu and you'll see "go to..." which expands to "related links".