CMS Database Universe - E-mail Recipients

[erdempekcan]

Hi,

I run the following query on Query Builder and I can get the results.

SELECT SI_NAME, SI_OWNER FROM CI_INFOOBJECTS WHERE SI_SCHEDULEINFO.SI_DESTINATIONS LIKE '%abc@xyz.com%' AND SI_RUNNABLE_OBJECT = 1

I want to have the destination dimension on the CMS Universe and added a new dimension as "Properties.si_scheduleinfo.si_destinations". However, it's always blank on query results. All other dimensions like Start Date, Schedule Type etc. can be retrieved.

Is there anything else required to get the destinations field to Universe and queries?

Regards,
Erdem

[TJe · Accepted solution]

I have tested a schedule on my machine and SI_DESTINATIONS is not a property, it is a property bag.

My guess is, that the driver handles only properties which you can get as dimension, but not property bags.

A possible solution could be the development of a plugin, just have finished the blog and the SAP Samples project that explains the solution: Get more insights with BI CMS Data Access Driver – add Objects or Virtual Tables

regards
Thomas

[erdempekcan · Accepted solution]

Thanks a lot for the check and help Thomas! I appreciate that..