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.

[Webi 4.x] Second Date


 
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
shravan_bo
Principal Member
Principal Member



Joined: 25 Apr 2006

Posts: 320
Location: Hyderabad


flag
PostPosted: Mon Nov 02, 2015 11:09 am 
Post subject: Second Date

Hi There,

My Report/query(Custom SQL) is picking top 3 sales based on the dates.

User has asked to show the data in dimensions are in Vertical and only Dates and Measures are HorizontalWhile trying to build the report. As per this 3 dates.

First date am getting First function and 3rd date getting by using Last function. Could you let me know how to get 2nd/middle date. I tried but no luck.
Like below per each Well and DP , data show same row(Horizontal) Metrics are coming based on rank.
Let me know how to get the second Date. I tried rank not working .


Well DP Date Sales Rev Date Sales Rev Date Sales Rev
E p1 1-Jan-15 12 3 56 2 23-Mar-14 34 21
E p2 1-Dec-15 23 6 23 323 24-Jun-14 56 23
D p3 1-Jun-15 45 26 23 23 1-May-14 2 34
D p4 4-Jan-15 23 84 67 53 26-Mar-14 5 2


Thanks in Advance
Shravan
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.0295 seconds using 18 queries. (SQL 0.0028 Parse 0.0009 Other 0.0258)
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