please help, Category-Label from Transformer to use in drill-through?

[Jeka]

Hi Guys,
Does anyone know if:

When the cube was designed: at the lowest level in dimensional hierarchy the surrogate-key was used as the source  but the category label was change to the business requirements.

Now, if i create a drill-through from cube to relational package. The value that is being passed is the surrogate-key, can i somehow pass the category-level description not the surrogate-key?

Thank-you for your Help!

[Jeka]

I figured it out with some Help!


You need to use....
(caption(members([Location])))

[twlarsen]

Hey,

Just curious, but where did you put that formula?  Are you able to use the caption in a report that is pointed at a relational package?


Todd

[Jeka]

I used this in the report that uses cube and the target is relational package report.

Is this what you asking?

Nikki

[twlarsen]

Yeah, I'm assuming your drilling from a report studio report to report studio.  At first I thought you might have been going from analysis studio to report studio, and was wondering were you would put a formula in an analysis studio report.  Guess I forgot we were in Report Studio question area!

Todd