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…

Tell your customer he bought a tool which require to create a bunch of schemas. He doesn't have to question anything: the RCU tool create the schemas, the RCU tool drop the schemas, no human (manual) operation is required inside these schemas. They must not be seen as database schemas but just as a piece of the…

Hi, Isn't what opmnctl already does? opmnctl stopall opmnctl status opmnctl startall You just need to add a piece of logic in between to check if status return everything is down. If you post more about the reason you look to restart opmn components like that it's maybe easier to give you a better answer. You maybe also…

More in general ... You do not have to touch these tables by hand! Never ever if do not know exactly how the scheduler and agents works (and what has a priority over what in defining things). This means you can only "read" content of these tables, and when you look at tables, based on the content and column names it's self…

Hi, Double posting is against the rules of the forum as it's considered impolite. You asked the same exact things Is it possible to use excel Macros in OBIEE 12c RPD and got an answer. Can you please close this thread? PS: a macro has never been a data source, so the answer will hardly change by asking twice

The rule is simple: - 1 or many subject areas use 1 business model (a subject area can't be using 2 or more business models) - a business model using 1 or many sources, same physical source, various physical sources, mixed source (so vertical federation, horizontal federation etc.)

I would more look at a single piece of CSS to be added to that page (to not affect things everywhere).

Hi, For more hints on how to achieve what you are asking it would help if you set a context ... As it's a client-server architecture the concept of "right after report runs" is a bit vague, as you can have none, one or 1258 concurrent users.

Hi, How do you know the issue is OBIEE? Isn't it your smtp server fixing the 5Mb limit? Because if it's on the mail server side you have to talk to your mail server admin as OBIEE can't do anything for you ...