How to get universe name of crystal report in BO CMS universe

Hi All,

How to get data source name of crystal report in BO CMS universe ?

I used [kind] =‘Crystal Report’ in query

I created variable in webi as below:

= [PropertyValue] Where([PropertyName]=“SI_UNIVERSE”)

But unfortunately i am unable to capture universe name/data source name being used for crystal reports.

Please help me out…

image

Thanks,
Shannkar

Hello @shannkar and welcome to B :mrgreen: B.
I recategorized your post to the server administration category as it is not really about developing with the SDK but creating a report against the SAP provided universe over the CMS. I didn’t want to categorize it to report writing either because it has more to do with deciphering what the SAP developers created.

I don’t have a clear answer for you. What I have found is that using Query Builder helps me to better understand the relationships between the data to figure out which Relationship tier in the universe contains the data I’m looking for. From there is seems to be a matter of experimentation to get the information you want. The universe is not intuitive in any way.

In fact, if you are just looking for a quick one report check for a Crystal Report data source, using Query Builder may be your best option.

Hi
according the LOV for Kind the value Should be ‘CrystalReport’ not ‘CrystalReport’.
then report name is in Name, Universe in Name (L1)
BR Tomas

1 Like

As already mentioned in another answer, the kind is ‘CrystalReport’.
For the used universe (unx or unv) you can use the Dimensions ‘Webi-To-Unv’ or ‘Webi-To-Unx’ from the Relationsships to-L1/Webi Folder. The Dimension ‘Name (L1)’ from the Folder InfoObjects L1/Common returns the name.
regards
Thomas

1 Like

Don’t “Webi-To-Unv” and “Webi-to-Unx” work just with Webi reports? The OP is working in Crystal.

-Dell

The property bags in the InfoObject have the same name, so the definition of Webi-To-Unv and Webi-To-Unx will work for all InfoObjects that have the properties. I have just created the Objects when I was testing WebI documents, so would make sense to change the Object names in the universe.

2 Likes

Thank you for the help, I’m able to capture crystal report Name¦¦data source name (universe name) in my audit webi report

Thank you