Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Drill Through a Calculated Column

Status
Not open for further replies.

yenfen

Programmer
Sep 2, 2003
34
US
Hi All,
Is it possible to drill through a calculated column in powerplay 6.6 ?
For example:
Col A = 30
Col B = 10
Col A - Col B = 20

When I tried drill through the calculated column, the impromptu report would only return 10 (Value of Col B).
What am I doing wrong?

Thank you!!
 
Are you calculating the field during the cube build, or is this a calculation you created after the cube was built.
If you are creating it in the mdl, you should be able to use it as long as you have a field in your drill that is named identical.
If this calculation is created after the mdc is built, I don't think you can pass it as a drill through field.

Pain is stress leaving the body.

DoubleD [bigcheeks]
 
Hi
Thank you so much for the quick response.
I'm doing the calculation after the cube is built not in the mdl. So it's not possible to drill through a calculation after the cube is built right? Unless I build a custom calculation within the model?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top