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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
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
murphy2k
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
key0
long name
member_value
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 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0291 seconds using 18 queries. (SQL 0.0025 Parse 0.0009 Other 0.0257)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo