Ignore my previous comment please. I found that user id was locked in identity could service. Everything is little different than on-prem . Will take sometime to get used to the interface. Still my usage tracking is not working though. Thanks Arijit

Sorry, I really wanted to mean OBIS. 

If the underline database is oracle, then you can use DBMS_FGA - Oracle Fine Grained Auditing. That can log every query run against Employee table. Thanks Arijit

I say it as he says "free" OBIEE. OAC is licensed by core so, it is free with essbase.

Are you saying you have "OAC" ? Oracle Analytics Cloud Service | Oracle

Did you try selection on Guest Name column ?

You can use selection step by clicking in the analysis. Then do something like this .. Thanks Arijit

Sorry, I did not read through the whole question previously. Really I did not had good success using rank function to sort my members. I remember trying it few years back and struggling to make it even return value. I had used hard coded case statement. Which I never liked but did the work for me. I have an idea about…

3227688 wrote:however it looks they they are with assumption that Gen 4 is the lowest level (i.e. level 0 in essbase) always. However from Essbase stand point, this is not always true and most of the time they are unbalanced.Thanks in advance. No it does not. If you understand the way that evaluate works along with essbase…

I haven't face any performance issue with OBIEE/ASO cube yet. I think OBIEE works better with aggregated ASO than BSO. Smartview also came long way since we were forced to ues it( loved excel add in). It's quirkiness is lot under control now. All said this is my assumption while working with the tool, I haven't done any…

@Robert Angel, I agree. Flat prompts are not good when you have lots of member in it. I have used another option with flat hierarchy earlier. A "special OBIEE alias" in essbase . Where the alias name is manipulated to add "__" for each generation. So It will look like ... root __A ____B Then you can choose what part of the…

Hierarchical prompt only works with hierarchical columns. you need to use hierarchical column in the prompt with a presentation variable and then in the selection area of hierarchical column you need check override with presentation variable.

OBIEE hierarchical prompt is rudimentary and hardly usable. One of the main issue is that it starts at generation 1 even when you have specific value selected. Most of the cases essbase hierarchy is deep and starting at the top is not an option.

look at solution 1 or solution 2 section ...you don't need relational database. It talks about all the different ways you can get the children of a particular member.

Yes, possible. You can use Evaluate . Look at this blog ... Oraculam: OBIEE: Generate Level 0 members dynamically for an Essbase upper level member In the blog you will see how you can generate level 0...in the same way you can also generate children ... For children , you can use EVALUATE('Children([@{presentation…

Really wanted to write Not possible out of the box. Yes, Java script can do it.

Answer to your first question, With help of java script you can do it. Look at this example... Business Intelligence: Javascipt to move print export link on top of report in OBIEE on the prompt question, "Not possible".

Can you also check if there is any conditional formatting in the section? If there is a criteria that might prevent the user to see it. Thanks Arijit

Check just the prompt object in the dash board. Check if the user has access to that prompt object. User might have access to dashboard but not the prompt object.

Check your instance config file for view / cube setting. When you say upto 10000 rows it supports, it tells me you might need to look at the limit set there. https://docs.oracle.com/cd/E21043_01/bi.1111/e10541/answersconfigset.htm#CIHHBHEB