DrillThrough Definition from OLAP cube to Report Studio

[Kezya]

Hello all!
I've faced with strange behavior drill through definition.

I have an OLAP cube that created in Cognos Transformer. Also I have a report that developed in the Report Studio and based on the relational package.
I need to create a drill through definition from the cube to the report.
I made the next settings:

[Kezya]

Please, find screenshot with passedvalues in the attachment

[Kezya]

And as a result there is empty param value in the report :(


In Cognos Transformet I set up CategoryCode for the level Month, the category codes are in the YYYYMM format. For example 201703 for the current month

In the report I expect this value

Have any ideas?

Thanks in advance!

P.S. In the parameters of drill through definition I try to pass the Level Category Code in the source metadata item.
If I change Category code to the Level name the report works

[bdbits]

In your passed parameters, it is taking the default behavior which is to pass a MUN from the cube. Obviously, this is not going to work.

What you need is to pass the value the report is expecting. This is likely either the business key, or the caption, it just depends on what the target report needs. You should find these options in the dropdown on the far right of that first screen - "Source metadata item properties".

[Kezya]

In your passed parameters, it is taking the default behavior which is to pass a MUN from the cube. Obviously, this is not going to work.

What you need is to pass the value the report is expecting. This is likely either the business key, or the caption, it just depends on what the target report needs. You should find these options in the dropdown on the far right of that first screen - "Source metadata item properties".

Hello!

Thanks for your answer.
I've tried to change the property "source metadata item properties" from Default to Bussiness key.
As far as I understood category code doesn't pass through drill through. Only the value from Source in the Level definition in the Cognos Transformer

Am I wrong?

[bdbits]

I do not have Transformer available to me right now, but what gets passed depends on the combination of what you have defined in the Transformer model (as in your screenshot) and what you choose to pass from the "source metadata item properties". I believe business key corresponds to Source. I cannot recall for certain whether caption corresponds to Label or Short Name, but caption is generally the value you see in a report based on your cube.

What you want is do-able, you just need to get things to match up, which can get tedious. At my previous employer I had created several package drill-through definitions and the target report was off a relational package that was also the input for Transformer. It worked pretty well, all things considered, and was especially useful for the users. Hang in there.