nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Deleted Presentation column is appearing again when we did the consistency check in OAS Rpd

Gopi Krishna P

In one of the subject areas, I have a ''Hierarchies presentation table'' from that table I have deleted one column, and I did the consistency check to save the Rpd but unfortunately the same column name is appeared again in the presentation table. I am unable to delete that presentation object.

If we delete the presentation table hierarchy in that presentation table and then delete the column means it was deleting the object.

I could not delete the related logical column and hierarchy because it was used in another subject areas also.

whereas in OBIEE 12c rpd it is working fine without any issues when I delete the object, if I keep the presentation hierarchy also.

I am using OAS 2023 version. Can you please suggest how to delete that object in OAS.

Thanks for the suggestions in advance.

Find more posts tagged with

Accepted answers

Federico Venturin - Oracle

Hi @User_DCJG6 ,

The Model Administration tool in OAS 2023 works slightly different compared to OBIEE 12c. When you add a hierarchical column to the presentation layer, then it must also contains all columns used as display columns in hierarchal levels. Otherwise the tool will raise an error.

If you delete column4, and click on File > Check Global Consistency > Report Only, you will notice that the tool raises error 38128 - Presentation level "xxx" has no display columns.

If you delete column4, and click on Save, then the consistency check will use the Auto Fix option, and will add back the column to the presentation layer.

I don't believe that this behaviour can be changed in OAS 2023.

All comments

Federico Venturin - Oracle

Hi @User_DCJG6 ,

I don't understand what you are trying to achieve. Can you please share a screenshot of your RPD and highlight the object that you need to delete? Are you working in online or offline mode?

Gopi Krishna P

Hi @Federico Venturin,

please find the screen shot above.

If I delete the column4 in the OAS rpd it was appeared again it is not deleting.

Gopi Krishna P

I am using the Rpd in offline only.

Federico Venturin - Oracle

Hi @User_DCJG6 ,

If you are working in offline mode, then you also have to save your RPD and upload it to OAS.

Once uploaded, I also recommend to navigate to the Administration page in Classic, and click on the "Reload Files and Metadata" option. This ensures that all the latest changes applied to the RPD will be available to the users.

Gopi Krishna P

Hi @Federico Venturin

Issue not with the answers and reports. Issue with in the Rpd only.

In Rpd - presentation layer

deleted object showing again in the same table in the rpd itself.

Federico Venturin - Oracle

Hi @User_DCJG6 ,

If you delete column4, and click on File > Check Global Consistency > Report Only, you will notice that the tool raises error 38128 - Presentation level "xxx" has no display columns.

If you delete column4, and click on Save, then the consistency check will use the Auto Fix option, and will add back the column to the presentation layer.

I don't believe that this behaviour can be changed in OAS 2023.