Syed Hamd Salman wrote:...from OBIEE 12c OPSS(Oracle Platform Security Services) are database based and it is still unknown(at least to me) where application role and group assignment are stored in OBIEE 12c onward There are a bunch of tables in one of the schemas created by the RCU, but it's isn't a simple relational…

Can you give it a try by creating the same analysis from scratch again? So do not duplicate it or copy/paste code but start from a new analysis and replicate it (same columns formulas etc.) and try to see there if the views works fine (no need to focus on the look and feel for this test, just the data and formulas and same…

Plan B similar to first option about row numbering: add an aggregation on your "appt time". Something like MAX or MIN depending on the one matching your logic the best. This will return you a single row and not 2 anymore.

Hi, To exclude a row you must be able to identify that row and filter it ... A possible way would be numbering rows by "name" (or "appt key" depending on your business logic) and only keep row number = 1, so all the others will be filtered.

Hi, Would help if you provide enough information ... What version, what's the context, does it works in other cases, does your charts have something special, does it work if you create a new analysis from scratch etc.

Hi, Did you try searching in MOS (My Oracle Support)? They have few matching document covering this error like for example https://support.oracle.com/epmos/faces/DocumentDisplay?id=1966781.1

I know, but that's why I added the "That's what you get out of the box: take it or leave it" ... As you said above and I also said: nowhere you find that list in a nicely accessible way. Sessions variable are based on sessions, so to get them all at once it means to code a lot by hand. And here is the question is: why? Why…

That's what you get out of the box: take it or leave it (because of all the reasons already posted above)

Nope, the usage of FILTER USING is the one giving you the problem as it is like hidden to the normal OBIEE logic (so passing values from an analysis to another etc.). So what you currently have is the less worse ... Sure take time to manage etc. But at least you can clearly control every single link.

Gianni Ceresa wrote:For the current active users connected to the system you can look in the Admintool in the Manage > Sessions menu.

On the Oracle sites you probably find only the 11.1.1.7.0 version (or 11.1.1.7.1 maybe), but then the one related to a given bundle patch is inside the bundle patch. If you download and extract the bundle patch you will also find it there inside.

Hi, The way you describe things all I get is that you are bypassing OBIEE completely but now expect OBIEE to solve your problem. Things doesn't happen magically ... Do you want to use a direct database request bypassing everything OBIEE does? Fine, so adapt your query to work based on the name and use that variable instead…

You take the problem from the wrong side ... If you need that version of Admintool it means you have a server with that version. So the admintool on the server is the perfect one you look for. In 11.1.1.7 the .exe is on the OBIEE server itself, just take it from there and problem solved.

Totally mixing things with the chat channel (isn't all about mashup nowadays? ), as they work for the same company I was making a kind of "shortcut".

In the end what @PedroF told you is right, trust him

Nope ... Navigating from multiple tiles to one report is fine, but your tiles are independent analysis. In that way you can know from which one you come from. If you have 2 tiles inside the same analysis first you had to cheat on filters (like you say) because you must use FILTER USING in the formula and the side effect of…

Cool So just one extra stop: close the thread (for now still This question is Not Answered.) and then enjoy your weekend

Hi, "Admin" mode is "help! help! something went wrong I can start but in a more or less useless way". Admin mode will not allow you to make anything useful for OBIEE. So open the log of the managed server and find why it start in admin mode

Raa.BI wrote:On google came to know about analyticsRes folder in OBI how we can schedule report into this folder. Sorry but you google the wrong thing as Christian said ... AnalyticsRes isn't accessible to users at all, it's a folder on the server, I hardly see how it can be accessible as it's the "shared folder" where…

3416402 wrote:Solved!Thanks. Sorry but .... No, that's not how it works. A community forum is a place where people share things, so great for you that you got a solution, but you don't just come back with a "solved". You share you solution so that if somebody else has the same issue he will find it. The concept being give…