doh! Though - there is no allusion to version of OBIEE - can he?

You mean like this -> Data Analytics Blog: OBIEE Data-Level Security with a Twist

Hi, you can create AGO functionality in answers as well as in the repository, so if you need to do multiple period comparisons then you might want to just use the necessary syntax in answers. What I was suggesting is that you might want to create a new measure for all of the non-time filtering that you were doing in…

Looking for this -> https://gianniceresa.com/2017/10/odc-appreciation-day-customize-style-of-lightweight-login-and-vadv/ Thanks to Gianni again!

So if you create a new physical measure that contains all of the logic you had previously had, using case statements rather than function filters, then you can create a logical measure using the AGO functionality to get a prior quarter, and with AGO it will have no issue with going 2018 Q1 back to 2017 Q4.…

And any good reason you have the content level set on the first but not on the second? Can you try with the second also set and see what result you get?

Amen to that, I hear you brother!

Thanks for stepping in - I lost the will to live when it was not what I asked for and does not even have business friendly names and all the keys were exposed....

Yes!

Hi, Really?! Yuk!! Okay, one do yourself a favor and do this with a well formed time dimension then you can easily have Quarter Ago, Next Quarter functionality etc using Time Series functions. Also split your logic down so you are not doing all of the heavy lifting in your analysis - i.e. create specialist measure for…

You do not say; - Your version of OBIEE What your time dimension looks like in the subject area in question? What logic you are using in answers to get the Current versus Next Qtr? The more information you tell people on the boards the more chance you have of getting a useful answer. Please give this a read; -

Hi, if you have an MOSC login then take a look at this; - https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/2095225_1.htm…

As Christian says fragmentation does work, I would; - a. Double check your data source actually has the values you think it does b. Double check that it always takes the first source by adding; AND 1=2 to the first condition and OR 1=1 to the second - if it fails in this condition then I would open an SR

Which version of OBIEE?

Yes, either rename it back or on every report that accesses it go to the advanced area and find and replace the presentation area name in the XML - or do the equivalent by hacking the catalogue - note hack is the appropriate term - better not to rename live subject areas! - and do back up everything before attempting said…

Hi, I have used fragmentation from two wholly different data sources and not had any problems, and on your exact version of OBIEE. Can you show a screenshot of your fragmentation set up?

Still not understanding why fragmentation would not work for you, couldn't you use a condition that is always true on the source you wanted, and a condition that is never true on the source you do not want, and drive the condition by variables?? Fragment1 (currently wanted) EnterpriseModel."Creation_Date" >…

Have you tried turning it on its head? You have it in text, why not turn it into a number; YYYYMMDD; this will take some case logic or similar in, conjunction with cast or similar. Then turn your date on the source table to a number using to_char / to_number and see if it works for you comparing number with number. It…

Agreed - I was more trying to understand if I had understood your trick correctly.

My trick would be set presentation variables and use the filter lock to ensure that the right variable and the right variable only filters the analysis in question. Doesn't your trick prevent indexes being used?