[IDT 4.x] Apply universe restriction

Not endorsed by or affiliated with SAP	Register \| Login
Not endorsed by or affiliated with SAP	Follow BOB on Twitter! (Opens a new window)
Index \| About	Sponsors \| Contact Us \| Calendar \| FAQ \| Rules and Guidelines \| Privacy Policy \| Search

General Notice: BOB is going to retire...please see details here.
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

Author Message

babu_272
Principal Member

Joined: 28 Jul 2010

Posts: 143

Posted: 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

Joined: 30 Mar 2006

Posts: 903
Location: Dublin , Ireland

Posted: 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

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: Follow @BOB_Board

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0261 seconds using 17 queries. (SQL 0.0025 Parse 0.0009 Other 0.0227)
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