Hi, Objects (meaning catalog objects) are referenced by using their absolute path, so if you search for the path of your given object in the whole catalog you find all the references to it.

Not really, OBIEE will see your JSON as what it is: a string ... But what you can do is to take that JSON and so something with it in a the visualization side with D3 or any other JS library as they manage JSON easily. It's just an indirect way of doing things ... An alternative way could be to add opaque views in the RPD…

Hi, You can definitely do it, just think more "analytics" and less database. Sure you can use EVALUATE and push that down in the database but then you will be strictly linked to your database with physical SQL in your analysis. Ideally in your data you would have a flag generated by your ETL (or something else) to flag…

Are these things measures? Or attributes? What's the aggregation rule in the RPD?

Hi, Let's go back to the beginning ... First of all: what's the exact version of your OBIEE? (including bundle patch) So everything is fine except your grand totals and to make it work you need to switch the "Aggregation Rule (Total Row)" from "Default (Sum)" to "Sum"? Or by default you have something else? What's the…

Thomas gave you the solution: a flag in your data ... Because what you are asking is something like: if there is a single negative value for any period then display the whole row, with all the periods including positive and negatives ... I would say you can still make it, but the conditions will be a bit more weird. What…

3506585 wrote:In 11g it is not necessary to set this settings. Are you really sure? Didn't you just set a system-wide default for that data type in your 11g? Because out of the box I'm kind of sure 11g always display numbers without any decimal ...

By ordering the columns you use on your X axis correctly you get the same, with axis labels not grouped and without the big spacing in between products. But you get the same kind of output ... from an information point of view ... As said by Christian: if you want exactly that then a JS charting library like D3 is what you…

Isn't this the same/strictly related to Report to display negative values only. ?

Hi, You maybe posted in the wrong forum or forgot parts of your message ... OBIEE doesn't store any data, so ... what are you talking about?

Hi, I will answer you with a question: are the jobs over? Because if they are in a running state (how long doesn't matter) and they aren't over there is not problem at all and everything works as designed.

When a prompt column is set to "SQL Results" instead of "All Column Values" you don't have the "Limits values by" option at all.

Well ... Not really ... Because it is a single unique measure column the format is unique and shared for all the values of the column. Even playing with some weird formulas you can only detect when the attribute is Actual or Plan but never the Variance (so no way to make a difference between Variance and Variance %)…

Ah, that's what I suspected You don't really have 4 columns, you just have 2 columns: one is the measure (ok, you have 2, Sales & COGS, but doesn't change anything) and an attribute (dimension). And you then select few values in the dimension (Actual, Plan, Variance, Variance %). In this case as the measure is a single…

What does your analysis looks like? Because if, as you say, you have 4 columns you can set the format on every single individual column. An Excel screenshot isn't helpful as it doesn't say at all how your analysis is...

With the information given the assumption of an issue in the model is the most obvious. Of course it's opinions in the end, as there isn't anything more factual on which to work. As you are had your RPD inspected by Oracle and had no feedback on changes or improvements your next step is to open a SR and manage it with…

I'm not sure if I would take "inspected by Oracle" as a guarantee of quality (when we see what they do in OBIA sometime I question myself if they really knew what they were doing and with which tool). Adding a measure with the rule in the RPD is definitely the best approach in this case. My opinion is that a self-service…

Everything is based on the RPD, so the answers to why this or that are all in the RPD. The logic on how queries are generated based on the RPD can change between versions, but if your model is "safe" before to migrate it will still do the same job in most of cases. If queries really change it's more because your model had…

As Christian said offline work on the catalog goes over security, so you find agents. What you don't know if they are really active or not as that depends on the entries of the scheduler, and that list you can get it from the database (if an agent isn't active and scheduled you don't care as the migrated state will be the…

This isn't an official Oracle answer or based on something factual ... My feeling is that you aren't allowed to have a dev server just because you have OAC. OAC is a cloud thing and if you want a dev server if will more be a cloud based thing (like another instance or running an OBIEE instance in the container cloud…