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
892

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
ayman_salem
Active Contributor
0 Kudos

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
Explorer
0 Kudos

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
Active Contributor
0 Kudos

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

ayman_salem
Active Contributor
0 Kudos

Result:

fmozas
Explorer
0 Kudos

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
Active Contributor
0 Kudos

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
Explorer
0 Kudos

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
Active Contributor
0 Kudos
could be, so try the latest version of the CMS univese.

but before that try with the user "Administrator"