Didnt get answer to this.

building semantic layer
1

Hi to all,

I have a problem creating a object in universe. I have a object node_nr which can be 1, 2 or 3. I want to have a measure for each of these nodes in a graph. But it isnt possible to show (for me!) each nodes at the same time in graph.

Can someone help me out this,

Thanks in advance

Murat

_________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Listserv Archives (BOB member since 2002-06-25)

2

Murat wrote:

< I have a problem creating a object in universe. I have a object node_nr

< which can be 1, 2 or 3. I want to have a measure for each of these nodes in >
< a graph. But it isnt possible to show (for me!) each nodes at the same time >
< in graph. >

Have you tried creating variables for each ocurrence? I believe you will need to use the undocumented “IF then else” in report variables. You might also try creating a universe object which you can filter via the where clause. Other then that you will need insight from other BO listers.

Michael Sykes
Data and Knowledge Management Lead
Alstom Power Inc.
2800 Waterford Lake Drive
Midlothian, Va. 23112

Phone: (804) 763-7279
Fax: (804) 763-3837
Cell: (804) 334-5081

CONFIDENTIALITY : This e-mail and any attachments are confidential and may be privileged. If you are not a named recipient, please notify the sender immediately and do not disclose the contents to another person, use it for any purpose or store or copy the information in any medium.

Listserv Archives (BOB member since 2002-06-25)

3

if I understand you correctly, you should do the following in BO Reporter:

create 3 new variables with a formula like the following:

= where <node_nr> = 1 (or 2 or 3, respectively)

Then include each of these 3 variables in your graph…

hope this helps

Wolfgang

Listserv Archives (BOB member since 2002-06-25)