Question Re: Missing information in Webi Report using BI platform CMS system database universe in Technology Q&A

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

fmozas — Tue, 10 May 2022 16:23:26 GMT

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?

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

ayman_salem — Tue, 10 May 2022 16:39:31 GMT

This is due to user security.

If the user does not have "view" rights to this folder, he will not see it when generating the report.

Try to generate the report with the admin user or another user who has the right to view the folder and its contents

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

fmozas — Wed, 11 May 2022 08:32:55 GMT

Hi Ayman,

But I don't understand why I can see the folder since the CMC (as show you here):

And with the same user, I'm trying to create a webi and making a simple query filtering for the ID of that folder and It shows nothing:

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

TJe — Wed, 11 May 2022 14:02:37 GMT

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).

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

ayman_salem — Wed, 11 May 2022 17:25:45 GMT

I check it on my test system and everything works fine.

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

ayman_salem — Wed, 11 May 2022 17:27:40 GMT

Result:

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

fmozas — Thu, 12 May 2022 08:41:40 GMT

Hi Ayman,

I understand what you want to show me.
But in my case, I suppose that if my user didn't have "view" rights to this folder, I would not be able to see the folder from the CMC console or from the webi report. However, I can see the folder from CMC.

Or I'm wrong?

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

ayman_salem — Thu, 12 May 2022 15:47:21 GMT

What I see in your screenshot, the id is from a WebI report, not a folder (see frs:........ .wid)

did you try again with admin user?

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

fmozas — Mon, 23 May 2022 10:42:31 GMT

Hi Anyman,

I tried it with a user with admin permissions and the result is still the same.
Could be problem of the universe?

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

fmozas — Mon, 23 May 2022 10:44:30 GMT

Hi Thomas,

We don't have access to QB tool.

I'll have to find another way...

Thanks!

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

ayman_salem — Mon, 23 May 2022 11:57:38 GMT

could be, so try the latest version of the CMS univese.

but before that try with the user "Administrator"