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

[fmozas]

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?

[TJe]

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]

Hi Thomas,

We don't have access to QB tool.

I'll have to find another way...

Thanks!

[ayman_salem]

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

[fmozas]

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:

[ayman_salem]

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

[ayman_salem]

Result:

[fmozas]

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?

[ayman_salem]

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?

[fmozas]

Hi Anyman,

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

[ayman_salem]

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

but before that try with the user "Administrator"