BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Sunset Ride 
Sunset Ride 

General Notice: BOB is going to retire...please see details here. All BOB forums have been converted to "read only" as of September 1st.
General Notice: No events within the next 45 days.

MSAS OLAP Universe

Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
Forum Member
Forum Member

Joined: 03 Dec 2010

Posts: 1

PostPosted: Fri Dec 03, 2010 4:45 pm 
Post subject: MSAS OLAP Universe

we are just started to test with msas 2005 - based universes and i have built a 'vanilla' version for test and discovery purposes. we are on boexi 3.1. it appears that the structure of the universe is accurately built but i have a couple of questions/problems. for example, one of my dimensions, costcenter is 'flat' and has the following detail objects (AS member properties, for the most part?):

cc name
long name
costcenter code techname

Q1: what is key0? webi report will return a '0' value for the 'all' costcenter dimension but nothing for the costcenter code dimension

Q2: in webi, i am able to query the member_name and the costcenter code techname, but no results returned for the key0, cc name, or long name. the latter two are definitely member properties in the cube and have values for all costcenter codes.

when i user profiler to examine the mdx generated form boe, the missing member properties are not part of the query sent from webi.

i have the same problem retrieving member properties for many/all of the dimensions.

can anyone shed any light on this?

Thanks much...
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0270 seconds using 18 queries. (SQL 0.0024 Parse 0.0008 Other 0.0237)
CCBot/2.0 (
Hosted by | Terms of Service
phpBB Customizations by the
Shameless plug for Moments of Light Logo