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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

[IDT 4.x] Date and Time Prompt for a Multisource 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
office_ninja123
Forum Member
Forum Member



Joined: 04 Jan 2013

Posts: 16



PostPosted: Mon Oct 08, 2018 1:58 pm 
Post subject: Date and Time Prompt for a Multisource Universe

I have a field in my Oracle database that has a Date with timestamp. The field is defined as a Date in Oracle and here are a few of the actual values:
08-OCT-18 11:00:10
08-OCT-18 11:30:10
08-OCT-18 12:00:11
08-OCT-18 12:30:10
08-OCT-18 13:00:11
08-OCT-18 13:30:10

This object is defined as a DateTime at the universe level.

I have a report based on a single source universe that uses this object in a prompt. I am able to enter >=08-OCT-18 11:30:00 and <=08-OCT-18 13:30:10 and I get the expected records returned. Yay!

However, I also have this object in a Multisource Universe. I have another report that uses this field as a prompt, but when I enter the same date/time range, I get 0 records returned. If I enter >= 08-OCT-18 11:00:00 and <=09-OCT-18 11:00:00 I get back all the records from 08-OCT-18, regardless of timestamp.

Based on this test, it seems the timestamp part of the date does not work as a prompt in a Multisource Universe. Has anyone encountered this problem and been able to find a work around?
Back to top
Debbie
Forum Addict
Forum Addict



Joined: 01 Mar 2005

Posts: 2786
Location: Cheshire, England


flag
PostPosted: Tue Oct 09, 2018 8:06 am 
Post subject: Re: Date and Time Prompt for a Multisource Universe

Have a look here: http://www.forumtopics.com/busobj/viewtopic.php?t=152613&postdays=0&postorder=asc&start=30

You probably need to use the generic formats for dates and times for multisource ...


Debbie
Back to top
office_ninja123
Forum Member
Forum Member



Joined: 04 Jan 2013

Posts: 16



PostPosted: Tue Oct 09, 2018 9:00 am 
Post subject: Re: Date and Time Prompt for a Multisource Universe

Thanks Debbie,

I am able to take my date object and format it to a Date, a Time, or a Timestamp using the CONVERT function in the Universe. When I have it as a Timestamp, the prompt in the report correctly lets me choose a date and a time. However, when the report runs, it doesn't seem to be taking the time portion of the date in consideration even though it lets me select a time in the prompt. It seems like I have the object defined correctly at the Universe level, but it's hard to tell.

So far the only "fix" I've found is changing the Universe from multisource to Single which is no small task. banghead.gif
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6635
Location: Connecticut, USA


flag
PostPosted: Tue Oct 09, 2018 2:49 pm 
Post subject: Re: Date and Time Prompt for a Multisource Universe

Multisource does distinguish between Date and DateTime, but I don't understand why it would allow you to enter the time portion but then not use it in the filter. Did you look at the generated Oracle query in Data Federation Administration Tool? That might give a hint about what it's doing.
Back to top
office_ninja123
Forum Member
Forum Member



Joined: 04 Jan 2013

Posts: 16



PostPosted: Tue Oct 09, 2018 3:17 pm 
Post subject: Re: Date and Time Prompt for a Multisource Universe

Thanks Joe,

I think that tool would be useful for Multisource Uni's. I've never used it, so yesterday I asked my team lead if we have that tool and/or if he knows how to use it/install it/etc... Then we just stared stupidly at each other and decided we didn't know enough about it lol.gif

I think I will do more research on the Data Federation Admin Tool tomorrow and see if it can shed any light. If not for this project, but the next MS Universe that comes my way. For now I've started re-making the Universe to a Single Source instead of Multi
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.0273 seconds using 17 queries. (SQL 0.0026 Parse 0.0009 Other 0.0238)
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