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.

[Webi 4.x] summarize data from query2 on "hierarchy" from que


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



Joined: 14 Jun 2006

Posts: 12



PostPosted: Tue Jun 30, 2020 9:12 am 
Post subject: summarize data from query2 on "hierarchy" from que

Dear Members,

i have two questions. May I ask you please?

In webi Report (4.x) there are two queries.
- Query1 has dimensions as Country, City, Product Line and Product Color
- Query2 has dimensions Produkt Line, Product Color, Sales Person and a measure Sales Rev.

I have two merged dimensions:
Prod_Line (Query1.Prod Line and Query2.Prod Line)
Prod_Color (Query1.Prod Color and Query2.Prod Color)

Question 1:
How can I Summarize Query2.Sales Rev in a table on Query1.Country and Query1.City?

Question 2:
How can I make a cross tab with Lines of Query1.Country, with Columns of Query2.Sales Person and Sum(Query2.Sales Revenue) in the cells?

Thank You very much in Advance!

Best Regards
dve
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web 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.0299 seconds using 17 queries. (SQL 0.0028 Parse 0.0009 Other 0.0262)
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