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…

In addition to all the previous: it's a good things to also don't take the opposite approach and fit everything into a single business model forcing things to stay together when it doesn't make sense. As an example a screenshot of the "core" business model of OBIA : tons of objects with a crazy amount of fact tables and…

Hi, Temoryian wrote:Is there something that I am missing to prevent this from happening? Yes, you are missing to post enough information to know what you did As that's an analysis (it looks like OBIEE Answers, therefor it's called "analysis", a "report" would be a BI Publisher report) you built yourself it's impossible to…

Hi, The theory is a star schema per fact table, but nothing forbid you of having these 3 star schemas into the same business model. This is actually how you do those things. A business model isn't a single star schema, it's more all the pieces representing a business need, knowing that each fact table need to be modelled…

3614817 wrote:Added it only the BIAdministrators group - same result... Don't you have any other app roles than BIAdministrator, BIConsumer, BIAuthor? Because those are just the out of the box application roles, but doesn't mean they are really used accordingly to their names. In a real environment I would expect these 3…

Hi, Sorry but I just don't get the question (and as nobody posted anything in many hours I'm maybe not the only one). What do you call "redy check" ? What is the link between certification matrix and functionalities? The certification matrix simply tells on which system OBIEE is officially supported, but it's always about…

In addition to the good replies already posted above, it's worth nothing that action links do different things based on what/where they are applied. An action link on an attribute column will act in a very different way than an action link on a measure column. As a general note you maybe want to have a look at and always…

Opatch is the truth, nothing else. If Opatch tell you that your patch is applied that's it. There has been various threads about versions not changed in the front-end etc, and the answer always end up pointing at opatch: sure it would be better if the front-end shows you the right thing, but as long as opatch says it's…

There are random users which are used by OBIEE for some housekeeping tasks. It isn't real users but more processes of OBIEE itself. As almost everything is done via webservices etc. they are still visible as sessions.

Does your dashboard contains (directly or indirectly) an object with HTML inside? The reference to "nbsp" sounds like ' ' which represent a space, but '&' if not correctly encoded break the XML parsing of the document, which is what the sax parser does.