Skip to Content
0
Former Member
Oct 24, 2011 at 06:04 PM

Adding new measure to Business Layer

32 Views

Hi Experts ,

I have created a relational universe on top of BW cube using information design tool. i want to add a new measure in universe ( in business layer, which is exported as universe). This new measure has to be calculated from an existing measure based on a value in specific dimension.

for e.g. select 'measure A' where 'dimension B' = 'XYZ'

After adding a new measure to business layer i see text editors for "select" and "where" SQL statements. is this MDX or normal SQL?

Has anyone done this or know about this? if yes, please let me know how this can be done.

Thanks for your help.

-Muru