Current Position:Home > Can Universe designer recognize hierarchies (nodes) define in a dimension t

Can Universe designer recognize hierarchies (nodes) define in a dimension t

Update:11-30Source: network consolidation
Advertisement
Hello,
Using BOE XI 3.1 SP3.
We have hierarchies (nodes) defined in our dimension tables.
Does the designer will recognize them? If yes, how?
Do we have to re-create these hierarchies in the custom hierarchy panel?
If the Universe designer doesnu2019t recognize these nodes defined in the dimension tables, which other SAP products will? OLAP (it will require creating aggregate fact table (cube) first, right?), Voyager?
Iu2019m looking for functionality similar to what Cognos-PowerPlay has.
Thanks.

The Best Answer

Advertisement
Hi,
Thanks for the interesting link.
If I understood well BO will take advantage of nodes/hierarchies defined within dimension tables only if the data resides on either a BW database or a OLAP (aggregated ) tables.  If my data source (star schema or 3rd normal)  is at the lowest atomic level then I have to manually defined the hierarchy via the hierarchy panel of the designer.  BO designer can't take advantage of what has been already defined in a dimension table.
Thanks.
  • Can Universe designer recognize hierarchies (nodes) define in a dimension t Update:11-30

    Hello, Using BOE XI 3.1 SP3. We have hierarchies (nodes) defined in our dimension tables. Does the designer will recognize them? If yes, how? Do we have to re-create these hierarchies in the custom hierarchy panel? If the Universe designer doesnu2019

  • DECODE SQL Function - Parsing error in Defining Objects in Universe Designe Update:10-11

    Hi, I have created a class and an object in BO XI R3 Universe designer. I am getting the parsing error while defining the object when using the custom SQL as select decode(matteraction,null,decode(matterissue,null,'MATTER','ISSUE'),decode(matterissue

  • Problem with Queries Structures in Bex Query Designer and Universe Designer Update:10-11

    Hi everyone, I have a problem when i try to do a Universe from a Bex Query Designer. When I use a Characteristic Restrictions in a Structure, the universe only show me the structure without the objects inside it. EJ: 1) Bex Query Designer Colunms (St

  • BW Universe with multiple hierarchies issue Update:10-11

    Hi,      We created an OLAP universe off a BW BEx query that has 2 hierarchies enabled.  Hierarchy 1 is 12 levels deep while Hierarchy 2 is only 5 levels.  Level 00 was also generated for better hierarchy reporting.  In Web Intelligence reporting, Hi

  • BPC 7.5 MS - Integration Universe Designer - Access to properties values Update:11-30

    Hello. I am working with BPC 7.5 MS SP03, and I want to do some reports with Web Intelligence. I installed the ODBO provider and I defined a Universe with Universe Designer. Now, my Universe has a class for every dimension of my AppSet, and I can do

  • OR between groups in Row-Restrictions, priority - Universe Design Update:11-30

    Old School Univers Design, no SAP source, but plain Oracle Two Questions here 1 - Priority in rowrestrictions from documentation: u201CYou can specify which restriction to apply to a user that belongs to multiple groups using a universe. For example

  • Universe design for SAP BPC (MSAS cube) Update:11-30

    During the designing of a Universe on top of a MSAS cube there is the moment I may select Dimensions & Hierarchies. Here there are ID's of my model, e.g. Accounts-Lev1, Time-Lev1, etc. How do I get to see the descriptions of the levels in the Univers

  • Universe Design - Linking two columns in a table to a subordinate table Update:11-30

    Post Author: bradwist CA Forum: Semantic Layer and Data Connectivity I hope this is the right forum to ask a question about Universe Design.  If not, please redirect me.  Thanks. I have a question on a universe design that I am trying to implement. 

  • How to remove the negative sign in universe designer? Update:10-11

    hi all, have used BEX query designer first to create the query, for the key figures, i have choose 'reverse sign' option and in the BEX analyzer report, it showing correctly with the figure having 'reverse sign'. however, the 'reverse sign' was not b

  • Row level security at universe design level Update:10-11

    Hi, I am creating a Universe layer on top of non SAP OLAP cube ( from MS Analysis Services 2005 ) . My concern is that can we maintain the row level or data level security at universe design level or if i am using that universe in creation of WEBI re