So you want to filter a measure by some values and in the same time group the result at a different level than the one of the analysis itself? Did you try it? Can't the same be achieved with normal analysis filtering? (sometime FILTER USING is abused for no real reason)

Hi, You probably want to delete the copy/paste of the MOS document you did as it's not allowed in a public forum. You can copy/paste MOS documents content when posting in . (MOS isn't freely available content but part of the paid support you get, therefor posting publicly MOS content isn't allowed)

I'm just going to repeat myself as I did in OBIEE CLONING : what's your target? You "cloned" an OBIEE install from A to B, but what's your final target? Because as I said there is more than just an IP and hostname.

If you go through all the above you find how to get rid of message. The question is: is that message really related to your issue? Farrukh Nasir wrote:Yesterday what happens that some of the users didnt get the email. Does this mean that for one given agent only some of the recipients got the email? Because that would be…

Hi, Sorry but not sure to understand what you are after as your example isn't really OBIEE: you talk about the FILTER(.... USING ....) function? Or you mean "filter" as a WHERE clause in a query?

Soheil Star wrote:We should add "APPS_LIBRARY_FOLDER_LOCAL" property on xmlp-server-config.xml file Really? That's exactly what Doc ID 2394388.1, posted 2 months ago, said to do. Can you at least close the thread as it isn't an open thing anymore?

It's worth to keep in mind that the real full list of recipients could be inexistant because based on an analysis, in this case you will need to run every and each analysis used as condition to get the list of recipients at that point in time. The best place where to get all the recipients (including potential recipients…

Ok, let's do a step back: what's your target in this cloning? Move that environment to a different server and decommission the old one? Or to get a second working independent copy (like creating a TEST or DEV environment from PROD) or a kind of disaster recovery environment you can turn on in case of issues on the main…

DUOS wrote:I request you to please share link for 12.2.1.3 if you have it. Regards Did you at least try to just search it? If you don't like the search in MOS you can use Google as it now reference MOS documents too (and I actually got a link there as first result for 12c).

Hi Charles, I just have really vague memories about this, but I would say it "visually" mark things in the Admin tool to highlight objects modified or created by your action. It's just a visual thing and I guess you can turn it off when done in the "File" menu ("Turn off compare mode").

This could explain why you don't have the right permissions anymore. Copying things like that is a bit a cowboy-style way of doing things, which could generate this kind of issues. Try to use Catalog Manager online or offline to set the right permissions on the "Shared folder".

Hi, What is the history of that instance? Is it a fresh install and you can't create a folder in a empty catalog? Or is that a migration? Because it sounds like somebody set some weird permissions on the root of "Shared folder". Or maybe a misunderstanding of how inheritance of permissions works and set a "no access" there…

Hi Sree, A good place where to start is https://docs.oracle.com/middleware/11119/biee/index.html . The doc cover a bunch of cases, including upgrade from 10g or patching from a previous 11g install. MOS probably also has some content. So read and search a bit and if you have more precise questions come back with those.

Didn't you miss something in your "sample" query? There isn't any aggregation, not sure why you even have a group by there as it's just a bunch of attributes and the distinct return you unique combinations only. With the provided info I really don't see the link between your mesure with a SUM aggregation and the sample…

SonPat99 wrote:Is this a better way or using IB and session variables to achieve a custom landing page? Honestly that page shows everything you MUST NOT do in OBIEE. The person writing that page has not a single idea of how OBIEE customization works as they randomly edit files. At the first patch applied on the system most…

I don't see your whole value, but it definitely starts wrong (not with a / ). Read again your MOS document you linked in the thread, the example they gave there inside is: /shared/_portal/Test3 I don't see the first " / " in your variable.

You can't click "OK" until a query is provided: (from the doc) If you select Database as the data source type, and select the Use OBI EE Server optionThe SQL statement you use to refresh the variable might be written for a specific database. However, it will still work with other data sources because the SQL statement is…

Just a little bored, having a break in my project with graphs and kafka, so going back to some OBIEE is a way to spend the day

Other hypothesis (yes, I'm just guessing as still there isn't much provided ), your columns aren't aggregated. You can check that in the generated SQL and force an aggregation to "compact" lines together and merge everything to give you back only what you look for. As alternative you can explore FILTER( USING ) instead of…

So your formulas are conditions based on 2 dimensions, right? And you display the 2 dimensions in a pivot: one as rows and one as column. In this case the output you have is right (because your formulas only match one cross of both dimensions at a time). What do you expect as result? Did you try to get rid of the 2…