Thanks @Lisa O'Kelley for the details. The question has been moved to the Publisher category so you can get a better answer.

You said "report" a few times: is this a Publisher report? Or is it an agent and your "report" is an analysis?

Ok, so you are on OAC and are trying to write that as a filter in a "classic" analysis. The thing is that you are writing Oracle Database SQL syntax, but the filter in a "classic" analysis does speaks LSQL. You simply have a language mismatch: you are using the wrong syntax, the wrong languages. In a filter you can only…

EBS isn't really covered in this forum but in two of the "parallel" forums. Try asking there. The question seems to be about data or EBS processes, therefore those forums will definitely be able to provide you more answers.

Nobody here can see your screen and know what you are doing, how, where. You should consider providing a minimum of context. Things like a product name and a version to start with, where you tried to enter that expression etc.

OAS 2022 is out error correction support dates, you should consider upgrading to a supported version (OAS has a lifespan of about 2 years, a version is supported a year after the release of the next one, and it is being released on a yearly base). Your source is Essbase? And the exact same MDX query is generated by the 2…

What Steve said … It isn't the XML of the analysis generating duplicates, it's more mistakes in the modelling, wrong logical keys and things like that, generating a different query. For example: does your RPD contain any warning or error? There shouldn't be any, you should fix them to start with a "clean" state, then…

Hi @User_5TZYH , As long as you didn't modify those tables manually, the way they are created by the RCU is covered by the OAS license. They are "product's tables", the RCU does create them the way it needs them. Of course it doesn't mean you can start using compression for free on your own tables, you don't have a license…

I imagine the question was meant to know if a "cheat" workaround could be achieved by using a pivot instead of a table. Still, the folder heading (by default being the presentation table name) doesn't exist as a concept in DV for now. For that one visualization example you posted, the cheat will work, but having to make up…

Hi, To be fair I never tried. That type of objects can't be created anymore, there are good chances the code has been fully removed. I imagine they will just be "unknown" kind of objects. I don't expect them to display anything useful (no data), and probably an error of "unknown" object could be visible in the page. But…

Hi, If you ask about a Fusion product, you should ask in (there are many categories, find the best match). This forum is for Oracle Analytics.

As far as I know, in a DV workbook the table and pivot visualization do not have the concept of "folder heading".

Everything you can do in OBIEE can be done in OAC: "classic" didn't move (except for OSSM that isn't there at all anymore). Therefore just do the exact same thing. Or maybe by "OAC reporting" you mean a DV workbook?

Yes, you can edit the exiting one or create a new one. The key point is that the dashboard that is "published" (in a shared folder) does NOT reference anything stored in your "my folder". It should point only to content also stored in a shared folder.

Ok, thanks for the details. So, it's the case I was mentioning. You move the dashboard from "my folder" to a shared folder. But the objects referenced inside the dashboard do not move. If the content (analyses) were in your "my folder", the dashboard you moved to shared folder is still pointing to the content stored in…

Hi, Do you mind sharing what product (name) and version you are using? What did you do to "publish your dashboard"? Was it between different environments or moving it to different location of the same server? Waiting for more details, if other users can't see the content (I assume the whole content, not just no data), it's…

Please don't triple post in many random categories. Instead invest time in writing a proper question with all the details (product name, version, what you tried, what you try to do etc.) to receive a reply.

Thanks @YewWan , I moved your question in the Publisher category to give it more chances for a valid reply.

Hi, Do you mind saying what product name and version you are using and which "piece" of the product you are asking about? Just to know if you are asking for "classic", DV or Publisher. Or maybe you are asking about a different product that isn't covered in this forum, but we could point you to the right place.

@Craig Garcia , no need to post it somewhere else, you asked in the right place. @Subha_Tripathy-Oracle , this isn't the FAW community page, it's the Oracle Analytics community. The question is in the Publisher category because it is a technical question about how to achieve something in a Publisher template. The data…