I would: 1) Create a table with all Department-Region combination for each user 2) Create a session variable that contains the list of Department-Region combinations for a user 3) filter the fact table using the session variable

Maybe a stupid question but... have you restarted presentation service?

R tutorials you can be found everywhere in internet LMGTFY regarding the related OBIEE implementation i suggest you to download the Sampleapp and have a look at the examples of R in there OBIEE Samples

Why don't you 1. create a "Fake Column" in the RPD like "Dim Variable"."Variable" 2. Create a prompt for "Dim Variable"."Variable" that manages the variable varDimName 3. create the prompted link using "&col1=%22Dim Variable%22.%22Variable%22&op1=eq&val1="Vendor"

Prompts can only be based on Subject Areas and can only execute Logical SQL. No physical SQL is allowed

Hi, No it's not possible. But you can always write logical sql in the query definition

Hi, yes You can improve in various ways like using D3 https://www.rittmanmead.com/blog/2013/06/embedding-a-d3-visualisation-in-obiee/ You can also use R, sample app has a section dedicated to embedding R visuals in OBIEE

Hi, This should reply your questions https://docs.oracle.com/cd/E28280_01/bi.1111/e10544/scorecard.htm#BIEUG1271

Hi, As a general rule I believe the more you push down to the RPD the better it is. If for example you create an analysis with three columns: Num, Den, Num/Den your SQL will probably look like SELECT NUM, DEN, NUM/DEN from TABLE But if you are only interested in Num/Den then creating an analysis with only Num/Den will…

what if you execute java -version ?

Hi, If you got the answer to your question you can maybe close the thread? It will help others with same/similar questions, right now it's still This question is Not Answered.

No worries @Christian Berg keep on trying...

Just to add to Christian's comment Every column that is not explicitly specified in the time series is creating a distinct subset of the data. If you substitute Year with Product then you'll end showing a different trend line for each product. That's the meaning of the group by. In you case is more difficult to understand…

Hi, Is there a way to select which lines/bars you want to show data labels for? No that's a ALL or NONE selection is there a way to select where to place the data labels? (Example: above, below, to the right etc.) No

Hi, By default obiee 12c charts use HTML5 no need to install Flash

Have you tried with a static text and HTML iframe? This is what the Embedded content does under the covers but with custom HTML you may have multiple options.

Hi @user1993962 Yes, you need to change the Users profile: 1) Under you profile, My account 2) Go to Delivery Options 3) Add the 1st Email Device 4) Add the 2nd Email Device 5) Create a new Delivery Profile 6) Select the newly created Delivery Profile as Active 7) In your "Destination" tab of you Agent, select "Active…

Hi, What you are looking is TRENDLINE(revenue, calendar_month BY calendar_year , 'LINEAR', 'VALUE') Anything that you include in your view that is not expressed in the series, it automatically gets assigned to the Grouping (by)

you're welcome Mark If you got the answer to your question you can maybe close the thread? It will help others with same/similar questions, right now it's still This question is Not Answered.

Is it working with the default style?