That was actually an open point: did you wanted a single column for your code/description or 2 different (one for origin and one for destination) ? So the answer is: a single one! Fine: add 2 LTS in the logical table and point once to the physical object joined as origin and one as the physical object joined as destination…

Sorry but I would go with Robert first answer... Christian: I see what you say, and it would be right but ... the OP clearly try to match both foreign key at the same time with a "AND", which is logically impossible (or you open the door to 1=2 in SQL, and you don't want that). Your proposal could work with a "OR" instead…

How is that supposed to looks like? Percentage compared to what? (as a percentage is based on a reference value)

How many licenses for OBIEE you have? (as asking in the OBIEE forum) Not really, nowhere you enter the licensing details. You have to have the required licensing but the tool will not warn to block you (but if you get an audit you will pay it !)

Hi, You need to fix your code ... If the first time it doesn't display anything and need to reload it to see something it sounds like you aren't managing events correctly, and try to make some work too early when things aren't loaded (and it works the second time as things are in cache). You don't provide anything about…

You are welcome Kathie. MOS is a jungle: some days you are lucky, other days ... less

Do you know what a pivot is, right? A thing where you can select an attribute ("week" in your case) which will be display as many columns as there are values. So select the "week" and place it in the "column" part of the pivot view, place the measure as the measure and place the other attribute(s) (the one giving you…

Robert Angel wrote:I was not suggesting an 'exotic workaround' ... Your is clean, it's the original 53 columns with a FILTER inside what I call "exotic"

Why do you use FILTER for 53 times? A pivot does that all by itself (or your model/data is just unusable and you maybe want to fix that one before looking for exotic workarounds in the UI).

Hi, You maybe want to have a look at https://support.oracle.com/epmos/faces/DocContentDisplay?id=2259016.1

Hi, If you use a pivot it's done by default: as the attribute "week 52" can't exist twice ...

Weren't you looking for the exe file? You got it, you don't need the path anymore, just take the exe.

you can add the CSS in the same dashboard page as a text element, it will not be visible on screen, as long as it's on the page you are fine.

Do we agree that you will look to setup a backup process for your OBIEE, right?

What you could try is to deploy a BAR (like the SampleSales one provided with the install), deploy just the RPD and see if it allows you to restart the system, then you upload your RPD. You do that by using "importServiceInstance". (Welcome to OBIEE12c: Using BI Application Archive (BAR) files ) Please beware: this command…

For the records, the deleted post was something along this like: My customer ask what and why are the permissions required on the various RCU schemas for OBIEE 12c. He was also asking, on behalf of his customer to describe every schema and what it was used for. So a typical "please guys, it's Monday and I'm useless, do my…

3512385 wrote:test - Please ignore You think you are smart by deleting the whole content of the post after asking things? Let's call your boss and send him our invoices for consulting services, on your side you can read the rules of the forum and learn how a community is supposed to work ....

It's not clear what you did and how you did it (online not requiring any restart but you "saved RPD and restarted"), you didn't say if you checked the logs and what they report. You are not trying to find a RPD but your system is down. Aren't you just running desperately in all the directions without analysing things first…

Why did you restart if you were working online? That's the thing with working online, changes are done "online". 3295595 wrote:Which backup? The one you do daily or weekly as part of your BI solution backup strategy... (it's an enterprise analytical platform and not Excel, as such you generally have a backup strategy in…

Restore a backup and you are fine ... And remember to not work online if you aren't sure of what you are doing (and documenting it a bit ...). You maybe also want to go through the logs to just make sure if your issue is in the RPD or maybe something else (how did the system go down? When working online it doesn't shut it…