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.

Hi Charles, The filename generally uses + as spaces and % could be any kind of special character, OBIEE also shorten names, so sometimes it's quite random. Just create an analysis with a similar name and then copy the XML file (not the .atr) from the user folder and override the one which has been created (so rename the…

What Joel said, adding a reference to the most known collaboration tool for OBIEE: OBIEE Commenting & Annotation Tool | Collaborate with BITeamwork As you seem to have quite some limitation with security they maybe are going to prevent you to use APEX as well. If it's the case try to fight that decision, but if really no…

Christian Berg wrote:In all honesty I'd go the file-system way: Create a new object of the same type as you're trying to recuperate. Then go and take the CONTENT of the object you want to recuperate - go inside the file and grab all the XML - and then go inside your new placeholder object, paste the code, save and that…

Did you copy the whole <userXYZ> folder? I would only take a subfolder or content as the main user folder contains bunch of "special" things (metadata files storing things) the catalog maybe get confused about. And you will still need to erase permissions to add yourself in it as by default only the deleted account will be…