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.

[IDT 4.x] Apply universe restriction


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



Joined: 28 Jul 2010

Posts: 143


flag
PostPosted: Fri Sep 20, 2019 7:26 am 
Post subject: Apply universe restriction

I have a universe which contains 50 different tables however want t restrict data to show in reports after 2018 only , how do we implement?
Back to top
jemstar
Forum Associate
Forum Associate



Joined: 30 Mar 2006

Posts: 903
Location: Dublin , Ireland


flag
PostPosted: Thu Sep 26, 2019 6:04 am 
Post subject: Re: Apply universe restriction

Create a self restricting join on all the tables that have a date field - typically the fact tables.

e.g. date >= 01/01/2019

Every time a query uses these tables, the self restricting join will be added to the SQL

_________________
James Halligan

Business Objects Contractor

http://www.jemstar.ie/

Available for Contract Work In Ireland (and remote work worldwide)

Expert in Universe Creation directly over Enterprise applications (JDE, BMC Remedy, EBMS, Jira, ArisG, Bespoke, Mercator, RAPID, M3, Movex, Investpro)
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.0266 seconds using 17 queries. (SQL 0.0027 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