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

OBIEE Object ID of columns

AAwas-Oracle BI-Oracle

Hi Experts,

If we look at Advanced xml of report, we see that every column(Attribute/metrics) has id .

Is it possible to extract a list of all columns and the object id of all columns ? Adding multiple columns in one go and then browsing through xml is one option but that does not looks like a good approach , more relevant for if nothing else works .

Do we have any other options to get the required list ? Request guidance

Cheers!!!

Anurag

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

1.) "Analysis". Not "Report". A "Report" means BI Publisher

2.) These IDs are proper to the analysis you are building and change all teh time when you add and remove columns.

I think you are missing a key part here since the question is a bit non-sensical looking at how the tool works.

As always: What are you acutally trying to achieve?

AAwas-Oracle BI-Oracle

Thanks for the reply, yes the question is non-sensical as it does not give a background. Sorry about that .

What we are trying to achieve may be difficult to explain in detail but in short we are trying to check the feasibility of programmatically converting user defined reports in xml formats to OBIEE understandable xml to be used in Advanced tab, starting with simple tabular reports.

The column names used in user defined reports are exactly the same as in our OBIEE metadata so I was able to pick from the user xml and convert to OBIEE understandable format but I was under the assumption that the ids are static and how may I get the same, but now, seems I could use a sequence generated dummy id ensuring that it is not the same for all columns in one single report and should be good.

Let me know if any suggestions.

[Deleted User]

3421308 wrote:What we are trying to achieve may be difficult to explain in detail but in short we are trying to check the feasibility of programmatically converting user defined reports in xml formats to OBIEE understandable xml to be used in Advanced tab, starting with simple tabular reports.

So basically you want a new custom GUI on top of OBI? Has already been done and it's open source:

https://www.rittmanmead.com/blog/2016/12/insights-an-open-source-visualisation-platform-for-obiee/

Gianni Ceresa

As OBIEE isn't an opensource tool there isn't a public available recipe on how the IDs are cooked.

But as Christian said they are generated when you add the columns in the analysis, their main usage is to uniquely identify columns in the context of the analysis itself. It doesn't look like these IDs are used outside the analysis so a unique defined ID is supposed to be fine.

Of course you will always have the risk to generate analysis which will break at some point, but that's obvious when you try to do things in a different why than how the tool is built.

Robert Angel

However,

suppose you invest months of development and create your interface and then Oracle upgrades and you find that something integral to your solution no longer works....

Would you really build your castle on sand?

[Deleted User]

In german we have a saying "Des Menschen Wille ist sein Himmelreich" - which basically boils down to "Whatever floats his boat".

At some point if people want to waste time, effort and money pointlessly just because it makes someone higher up in the food-chain happy - go for it and run the initiative into a wall :-D

AAwas-Oracle BI-Oracle

Thanks, but its not GUI over top but conversion which we were trying to check.

AAwas-Oracle BI-Oracle

Agree to your point, but that is a part of the disadvantages of actually going for a interface . Decision making will definitely have to put all that in consideration, at present its just a feasibility check which we are doing.

AAwas-Oracle BI-Oracle

Herr Christiain :-) Agree to what you stated but every capability in product impacts every single customer, can't speak much of the required for know reasons. So its not just one person's wish .. But In a sense somewhere line has to be drawn.

Thanks for your time and support. Merry Christmas .

AAwas-Oracle BI-Oracle

Thanks for your response and support . Merry Christmas