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: Upcoming Events: IBIS 2018: Jun 18, BI & HANA 2018 Prague: Jun 29.

[Deski (XI)] Can't match data in 2 dataproviders


 
Search this topic... | Search Desktop Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Author Message
highscreen
Forum Member
Forum Member



Joined: 01 Mar 2018

Posts: 2



PostPosted: Thu Mar 01, 2018 3:46 am 
Post subject: Can't match data in 2 dataproviders

Hi Experts,

I am trying to build report in Deski and faced with a some issue.
there are 2 queries in report.
1-st:
Country | Region |Customer | Category | material | qty
Country1| Region1| Customer1| Category1| material1| 1
Country1| Region1| Customer1| Category1| material2| 2
Country1| Region1| Customer1| Category1| material3| 3

2-nd:
Country |Category |materials |coefficient
Country1|Category1| material1| 1.0
Country1|Category1| material2| 1.0
Country1|Category1| material4| 1.0

Need to build table like:
Country , Region, Customer, Category, material, qty, Coefficient
Country 1, Region1, Customer 1, Category 1, material 1, 1, 1.0
Country 1, Region1, Customer 1, Category 1, material 2, 2, 1.0
Country 1, Region1, Customer 1, Category 1, material 3, 3, -
Country 1, Region1, Customer 1, Category 1, material4, - , 1.0

Is it possible to realize this on table level via formulas and datails? or we need to calculate on a dwh side with an intermediate precalc. tables.

Tools: BOXI XI 3.1 sp6, Oracle 11g.

Any suggestions.
Thanks in advance.


Last edited by highscreen on Thu Mar 01, 2018 8:46 am, edited 1 time in total
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14030
Location: England


flag
PostPosted: Thu Mar 01, 2018 3:52 am 
Post subject: Re: Can't match date in 2 dataproviders

Welcome to Bicon_mrgreen.gifB!
Look in to merged dimensions.
Back to top
highscreen
Forum Member
Forum Member



Joined: 01 Mar 2018

Posts: 2



PostPosted: Thu Mar 01, 2018 5:10 am 
Post subject: Re: Can't match date in 2 dataproviders

Nick, thank for your fast response.
Unfortunatelly it doesn't work.
I get result:

Country , Region, Customer, Category, material, qty, Coefficient
Country 1, Region1, Customer 1, Category 1, material 1, 1, 1.0
Country 1, Region1, Customer 1, Category 1, material 2, 2, 1.0
Country 1, Region1, Customer 1, Category 1, material 3, 3, -
Country 1, - , - , Category 1, material4, - , 1.0. - is wrong, because need to have possibility for setting filters on customer and other dimensions

Main issue is appending a set(category,material) from query 2 for each Region and Customer and adding this not empty string into customer if it is not in query 1.

Qty for added string may mark as '-', ' ' , 0. It doesn't matter.

Hope, it is possible to realize via details/formulas/ additional queries with union.
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14030
Location: England


flag
PostPosted: Thu Mar 01, 2018 5:22 am 
Post subject: Re: Can't match date in 2 dataproviders

Suggest you read a bit more about merged dimensions and what you csn do with them.
Back to top
bonotatsujin
Forum Member
Forum Member



Joined: 19 Dec 2017

Posts: 5


flag
PostPosted: Mon May 07, 2018 4:36 am 
Post subject: Re: Can't match data in 2 dataproviders

try link country to country, category to category. and make materials DETAIL
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  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.0227 seconds using 17 queries. (SQL 0.0121 Parse 0.0003 Other 0.0104)
CCBot/2.0 (http://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