Hi, The syntax is bit different here. Please refer to this article https:/ /blogs.oracle.com/ExalyticsOBIEE/entry/how_to_pass_presentation_variable. More examples here http://gerardnico.com/wiki/dat/obiee/presentation_variable

Your Analysis needs to be on a dashboard page. Then once it is run, the user can click Return where the prompts will be visible again.

An Analysis will produce a logical SQL and in most of the cases a single physical SQL. I am thinking whether or not there's a way that I myself can write a physical SQL that will produce two separate result sets when there's only a single WHERE clause. Would creating two separate Analyses and displaying them on a single…

Hi, I assume that the issue is when more than one date value is passed, it only accepts a single one. I have tried to simulate the issue though it's based on a simple scenario. I have a column prompt that can accept one or more than one date value. I have an analysis that based on the value(s) input displays data for those…

Did you consider Calculated Item? Above, DayCustom is a ((sum for all the hours) * 2). custom formula for Total in pivot table

Hi, Below is a link that can be useful in integrating two subject areas using Advanced SQL. The SAs in the example (URL, below) are based on a single BMM but I have checked in my environment that it works even if the SAs are based on two different BMMs (screen shot, above - NOTE: It does not show the BMMs).…

Hi, If the business actually functions like that and the sources can support the second model, using ETL and changes to the fact table definitions (or may be new versions), do you think that it is possible to link Fact1 to CD and Fact2 to CD, directly? You may be able to retain the existing relationships in the newer…

Got little idea about the issue. Hope this helps. Edit: OBI EE version 11.1.1.7.0.

Hi, Right now it's Friday evening so not in front of a computer. But I can fairly guess what you are trying to say. However, as previously mentioned by Thomas Dodds, those two are different measurements as the calculations are different. Personally, I would keep them separated so that it's less confusing to the users. Have…

Your original post did not mention about -7 days?

Here is a Pivot Table view albiet with a bit different layout. Associated Table view is for verifying the Pivot Table view output. Hope this helps.

With a change to the view, that is, instead of a Pivot - a table view, I could achieve as per a screen dump above. Group Output = (Sum(Revenue for Year) * Sum(Billed Quantity for Year)) / Sum(Revenue for Year) Row Output = (Revenue * Billed Quantity) / Sum(Billed Quantity for Year) A Static Text view explains what the…

That's fine. I am waiting for an update from the OP.

Hi, I mean due to security I can't access the environment. Sorry for the confusion caused. Regards.

Has this been resolved now? Sorry I can't access the above URL. Please update. Thank you.

how to get Value of previous row

Will filters based on another analysis work in your case? Edit: If the attributes are based on a same dimension, I would think there won't be any issue in giving correct results. If they are from different dimensions, then based on fact table (of the base analysis), I think, they would form a correct combination as well,…

I think 'Chpater 16: Usage Tracking' of 'Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial' book covers the topic and will be useful to you. Hope you get a chance to go through it. Regards, Manoj.

Some hint might exist here. How to return current month There seems to be an issue with data types around database column, RPD physical column and conversion. Why would one define a LONG datatype for a date value? Regards, Manoj.

Hi, Has anyone experienced an improvement with respect to the Line Graph's alignment in next versions of OBI EE? If it's improved then that will be one of the reasons to go for an upgrade. Thank you. Regards, Manoj.