Skip to Content
author's profile photo Former Member
Former Member

Olap universe(creating new object)

All,

I am using bo 4.0 version and i have created an olap universe on top of bex query.i am new to olap universe.

I have a need to create a new customized object in my olap universe out of two existing objects.As of now i am creating variables in my webi report generated out of the olap universe to fit my need.Instead i want to create a condition object or some kind of object in the universe itself.

how can i do this?Any ideas or suggestions.

For ex:

my requirement looks like this,not exactly the same as indicated below but similar.

existing objects

city object has certain values 'hyd','new york'

currency objecthas 'rupee','dollar'

new person object out of the above mentioned existing objects

if city='hyd' and currency='rupee' then 'indian' else 'non indian'

how can i do this?Any ideas or suggestions.

Regards,

Reji.

Edited by: reji2011 on Dec 7, 2011 11:10 PM

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 08, 2011 at 10:01 AM

    Hi,

    there's a function builder / formula editor in Universe Designer, with OLAP universes this uses MDX syntax with XML markup.

    to build up some logic, you need to use the "IIF" operator.

    regards,

    H

    p.s. in BI 4.0, route-one should be the BICS BEx connection, not the OLAP .unv ..

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.