Hi APsikus, I am not saying duplicates I am saying that you have unmapped columns at a level of detail. If you click on the column definitions then if (say) you have 2 (say) tables in the LTS then you will see 2 rows also for every physical mapping, assuming the columns you are looking at can be used with the corresponding…

It always amazes me that business foibles / taste drives excessively over engineered analyses / reports which also drives excessively expensive to create and maintain analysis / reports. I would push back with "if you take the default colours it is a X day job to create and over time will require no additional maintenance.…

Hi, incorrect logical table source likely means that you have multiple LTS for your dimension to fact relationship for pre-aggregation. My educated guess (not having sight of your rpd) would be that if you look at the columns you have used in the report then some of them are unmapped for a level / LTS.

You cannot create another dimension purely using modelling in OBIEE, sorry that is not an option. You have three options; - 1. Remodel the database on the Essbase side 2. Create a new database that is identical to your current but with one new dimension with only one member, load data into it, use this for OBIEE reporting…

Sorry, you are right, I cannot open the blog either, but as I said the advice is basically add another dimension which only has one member in it, which as I say worked for me as I already had that one dimension, if you are looking at Essbase through Planning and Budgeting or similar then I know that 'add one dimension'…

It has been a while since I had the dubious pleasure of Essbase through OBIEE, but I remember getting around this by having a dimension that was not filtered on, in my case this was lucky as we had the Essbase set up for multi-currency but in practice the client used only one, so we did not need to filter on that dimension…

A manual division? If you mean inputting whatever number you like then you could have a calculated field that is driven by a presentation variable that is set by a dashboard prompt?

Hi, if you use a pivot table then you can add a calculated column, cf example below - Step 2 https://docs.oracle.com/cloud/latest/marketingcs_gs/OMCAA/Help/Insight/OtherTutorials/FormattingPivotTable.htm

Yes - that is less than intuitive - but I didn't have access to an OBIEE instance when your question landed - glad you got there!

Btw - remember the presentation variable 'trick' previously, you can also use this when you get prompts writing over values you do not want them to by using the presentation variable for the prompt value and then using the lock filter functionality.

Look in your dashboard prompt definition, you can set the scope of it to page or dashboard, select the former on the prompt in question and your problem is solved...

Gianni's suggestion is better, as it saves unnecessary processing time. But, yes, you cannot use presentation variable with between, you would have to break it down into From / To PVs to make it work.

I had forgotten all about prompt before opening - nice catch!

Hi, if you set a presentation variable with your department prompt then you can use it as the value for your filter and have the presentation variable default to a value which will yield no results. @{PV_Department}{NoValuesWantedHere}

It looks like this is the source of the problem; - What is the fully qualified name of the physical table?

lol I have been on a number of SC projects where open source is just unthinkable. I guess we call it "open source" because "unverifiable content created by who knows who for an undocumented purpose which is completely without support and which could contain trojans, security holes and other deliberately malicious code'"…

If you have a local Oracle database that could be used in conjunction in OBIEE then you also have the option of using external table functionality, there if the source file changes the data changes, but I have not tested performance on this with larger data sets.

You know what you have just said applies to the entire open source tech stack, but still it gains momentum...

Though if you can access the space you are doing better than me this morning!

Yes.