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: No events within the next 45 days.

Custom hierarchy List of values in UNX universe (BO 4.2 SP7)


 
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
cajamarquino
Forum Member
Forum Member



Joined: 09 Jul 2019

Posts: 1



PostPosted: Tue Jul 09, 2019 11:18 am 
Post subject: Custom hierarchy List of values in UNX universe (BO 4.2 SP7)

Hello,

I'm currently converting UNV BO universes to UNX and i have a problem with the Lists of values based on a custom hierarchy in some universe.

A BO report working well on the UNV universe encounters a problem when I change the source of the Data Provider to the converted UNX. And analysing the situation, the problem seems to be with these lists of values with the creation of a subselect for geting prompt value.

For exemple, the following sequence :
( @Select(Time\YearMonth) <= @Prompt(Select a Month:)

is replaced by

( DIM_TIME.YearMonth ) <= (SELECT convert(char,DIM_TIME.YearMonth)
FROM DIM_TIME
WHERE DIM_TIME.YearMonth = 201801
)


which doesn't work because the result of a select contains several values for one given YearMonth

instead of expected

( DIM_TIME.YearMonth ) <= 201801

The result is the same when i try to create manually a new "custom hierarchy" list of values.
But i have no problem with the prompts corresponding to lists of values based on the Query Panel.

Any idea what is happening ?

Benoit
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.0264 seconds using 18 queries. (SQL 0.0024 Parse 0.0008 Other 0.0231)
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