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