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…

It has the limits of the search in the catalog page, so no, permissions only allow you to search in your own user "my folder".

Let's call it "flexible" design Most windows can take almost any aspect ratio and size: good for many things but you then pay that "flexibility" if you do not remember that.

DollyG wrote:I am using a different approach, instead of all column values, I am using 'SQL Results'. Hi, As you are not using what the product provides as functionality you can't expect to have a feature allowing you to fix the issues you got when not using the product functionalities. As soon as you move into "SQL…

Let's go back to basics on "resizable windows" Or it means you have no LTS at all, which means you can't do anything with that column anyway ... And as Christian wrote already you can do the same going through the logical table source (open that one and you find all the column mappings for that LTS).

875299 wrote:... and another for counting sku code's from random fact table.since for the counts it is hitting a random table ,i get wrong counts. Honestly in almost 10 years using OBIEE I never saw it using a random table. It uses what you designed and modeled in the RPD, I don't imagine it being really random. And…

Hi, I would say the wrong tool for the job ... If you export the CSV it will be faster and probably not have the issue. CSV will export the result of the query instead of export the result of the view like Excel will do. And last option: why don't you connect to OBIEE directly by ODBC and run a logical query against OBIEE…

The extend a bit the concept : you can easily get a list of enabled agents on the old system, you can easily enable them by code => you can script that. Plan B: being a one shot thing you enable them using the provided dashboard by checking the ones you need by hand (up to you to evaluate if it's worth to script things on…

Hi, Sure you can, but it's up to you to select the ones to enable because of what an agent is and how it is managed in OBIEE. https://gianniceresa.com/2017/03/obiee-12c-agents-enable-them-by-code/ https://gianniceresa.com/2017/03/scripts-to-use-agents-in-obiee-12c-mass-enabling-and-execution-from-a-page/

Hi, Did you looked at the generated queries in the 3 cases and compared them? First the logical one and then the physical one? Did you manage correctly the default value in your analysis for when the prompt isn't set? Is your cache on or off?

Some extra reading with a direct link to time series functions: https://gianniceresa.com/2017/01/time-series-functions-why-how-what-where-obiee/ https://gianniceresa.com/2017/01/sequence-numbers-time-dimensions-new-obiee-12c/

Just for the part about having a not adapted network configuration on a laptop vs a server or a vm: in your log at some point you have something like t3://DESKTOP-1Q20P03:9500: [RJVM:000575]Destination 169.254.137.174, 9500 When you have a 169. address its when windows assign itself an ip address because no connection.…