Sorry, missed your 'last' month requirement, for this you really need the quarter to be in your hierarchy then QTD (To Date measure built against the Quarter) measures would be ideal. You can probably also do it with case logic, but given your additional 'last month that has data in the quarter' then what I describe is…

Best way to do this is to build it into your time hierarchy, especially if it is a corporate need that will be heavily used throughout your subject areas. To do this you would have a hierarchy as below Total ¬ Year ¬ Quarter ¬ Month ¬ Date (if applicable) Then merely by having your fact measure(s) defaulting to sum by…

Just found my own fix. And this is really 'dumb'. The presentation layer is very long. I noticed that when I cick in the white space to the right of the subject areas that the subject area that had focus in the presentation layer did not lose focus. This meant that the short cut menu presented was contextually related to…

Hi, Sorry, this is NOT an option because this is modelling against the OBIA rpd which has a truly massive business model called 'Core' which contains pretty much everything.... thanks for your input. Robert.

Have you checked that the LTS for both FACTs have the correct settings to the appropriate level of detail for all of the conformed dimensions involved? Have you also checked that you have appropriate keys set for the dimensions.

Hello again Thomas, the columns need to be in both filter and display columns. I have noticed that the side effect only happens on larger data volumes, could this be related to configured limits on streams / java heap etc? thanks again, Robert.

Hi Thomas, on export, I could not agree with you more, but since when do end users listen to us... On the criteria, this is classic action link where the end user clicks on a value in the source report and this 'throws' parameters that are 'caught' by filters (is prompted typically, though also presentation variables)…

Many thanks to all. I thought Sprüngli was something you got at a certain nordic flat pack furniture outlet?!

Hi Christian, yes - I am using presentation variables but what I am struggling with is trying to get the presentation variable to default ALL values when nothing is selected, the same way that Is Prompted would, is there any workaround for this - as with that final piece of the puzzle I would be home and dry.... thanks for…

Ok, I found a fix to this. 1. Ignore the analysis idea it is limited 2, Write the equivalent of the nested analysis, but solely to retrieve its SQL from the advanced tab 3. Turn the filter in your outer query into sql and then paste the inner sql to be the basis of your IN condition 4, You will need to put your parameters…

Hi, the problem was as 'dumb' as the fact that the default on the prompt was not compatible with the data in that environment....

One more thought is check the properties on the column to make sure that the type and size are sufficient for the column

Check that the logical table source content is set to give the correct granularity between fact and dimensions, on both the fact and dimension side. Check all your joins are valid. Check that you have an aggregation rule on your fact measures. The SQL you post seems to indicate that it is only pulling from one table for…

1. You can use OBIEE in conjunction with single server sign-on. You can use BI agents to send OBIEE reports via e-mail without users ever logging in. You can generate html pages from OBIEE and publish them to a web site. In short OBIEE is a powerful tool and with the right people can achieve powerful results. 2. Stand…

Embarrassed not to have seen that before / found it - excellent - thank you!!!

Yes, exactly that - how is this done? many thanks for your input, Robert.

The reason I ask on documentation is when I am trying to follow the advice in the original to deploy the 'analyticsRes' directory I am not finding the described path under BiFoundation; - "In the Install Application Assistant dialog, provide the path…

Thanks for your input! Is there anything that documents the degree of 'slightly differently' and do you know of anything that addresses my requirement as the document only discusses look and feel, javascript / iframe is without mention. Thanks again, Robert.

No reason you couldn't make your default value the thing you wanted to show, and change the filter on that column using a case statement to change it to the column in question (so it is always equal itself - if you want your default to show all values!)

Have you seen => http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/otbi_ent/rel10/perform_initial_config/perform_initial_co…