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!
I figured it out with some Help!
You need to use....
(caption(members([Location])))
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
I used this in the report that uses cube and the target is relational package report.
Is this what you asking?
Nikki
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