Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Use dimensions in measure expression
Migrateduser
<p>Hi all,</p><p> </p><p>I need to use dimension object into a measure expression. Once <span style="font-size:14px;">built the cube with, for example, YEAR dimension and AMOUNT measure, how can I add a new measure in a crosstab like:</span></p><p> </p><p>AMOUNT_NEW = AMOUNT / "NUMBER OF ROWS EXTRACTED FROM YEAR DIMENSIONS" ?</p><p> </p><p><span style="font-size:14px;">Is it possible? I can't find a way... I thought there was something like:</span></p><p> </p><p><span style="font-size:14px;">dimension[TIME][YEAR].count</span></p><p> </p><p><span style="font-size:14px;">thanks in advance,</span></p><p> </p><p>Massimo</p>
Find more posts tagged with
Comments
There are no comments yet