cancel
Showing results for 
Search instead for 
Did you mean: 

Missing information in Webi Report using BI platform CMS system database universe

fmozas
Explorer
0 Kudos
879

Hi,

I'm using the new CMS data access driver for BI 4.2 to query the metadata of the CMS repository database. I'm trying to create a webi report with all the existing folders in the BO system.

Validating the information that the report brings out, I have realized that it doesn't show me folders that I can see from the CMC console.

I have tried to made a simple query filtering by the ID of one of the folders and it cannot be found in the universe.How is this possible?Problems with the permissions or some problem of the universe maybe?

View Entire Topic
TJe
Product and Topic Expert
Product and Topic Expert
0 Kudos

Can you please check this with a query using the Query Builder:
select si_id, si_name, si_kind from ci_infoobjects, ci_appobjects, ci_systemobjects where si_id=<no>
(hopefully the query syntax is correct, cannot test it).

fmozas
Explorer
0 Kudos

Hi Thomas,

We don't have access to QB tool.

I'll have to find another way...

Thanks!