
General Notice: BOB is going to retire...please see details here. General Notice: No events within the next 45 days. |
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 |
|
 |
|
|