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

 

Dynamic drill through from OLAP cube to report studio report is not working

Started by jd, 17 Mar 2010 01:45:23 PM

Previous topic - Next topic

jd

Hi,

I am working with dynamic drill through form olap cube to relations report studio report.

dynamic drillthrough is not workign with the Labels.
in Transformer I have dimension like Cog
source= Cog
Label = Cog Label(calculated column)

in report studio report I have Cog and created Cog Lable with matching name and calculation with cube format. Still dynamic drill through is not working.

if I delete the Label drill through is working fine. But I must use the Labels in the Transformer.

Any idea how to resolve this issue??

IceTea

Can you give me a hint what is "Dynamic drill through"? Is it the way to create a Drill-Through-Definition in Cognos Connection?

In my opinion, normally the Source (in your example: "cog") is used as filter-parameter in the target report. You can check this in your target report with a layoutcalculation with "ParameterValue" (not: "ParameterDisplayValue") on the transfered item, so you can see what is delivered.

From Cognos 8.4 on, you can chose within a Drill-Through-Definition, which element should be transfered/used in the target report (business key, label, dimension name, hierarchy name...).

jd

Hi Ice Tea,

Dynamic drill through should work without filters in the target report. Target report has filter based on the parent report (in my case which is the powerplay studio report.)

My Target report is relational report. do not have any business key/Labeletc....

actually Transformer cube has Labels(calculated columns), I have created same calculated columns in the report studio report and matched the column names with cube. even though dynamoc drill through is not working.

One more thing if I delete the labels in the transformer dynamic drill through is working fine.

But we must use our labels in the transformer.  I am not sure why the labels are not working