there is no more comments !!

To get the FolderPath of for example a WebI document or a universe, you have to use the Relationship ParentFolder. The FolderPath will be in Level 1 information. You can find an example query in the universe:

I have imported the sample universe and reports. When I create a new WebI document, I'm asked to select a Universe. As soon as I select this Universe and click OK, I immediately get this error:

Specified RDBMS is invalid : SAP BI platform CMS system database

I just created the connection with success, but related universes are not listed in IDT, how can I get the universe/sample reports?

Hello David, Sylvain, 

It's very usefull.

In the video, we see the "BI on BI - High Level View / Board", is it a sample ? Is it possible to download like the others sample ? 

Thank

Goulwen

HI Thomas,

When importing the Universe and refreshing the sample report it gives me below error message:

The following Database error occurred(CS): "Open connectivity driver error :No query filter defined".

Thank in advance

Sorry,Thomas it was not a sample report  what I mean was Sample Universe. I dragged one of the object in object pane and tried to refresh it.

I got this above error message.

Hi Thomas,

I'm loading the new set of packages into 4.2 sp3 and am struggling to get the SAP icons to show in WebI in the browser (IE8, Firefox and Chrome, HTML and Java panels).

They show fine in WebI Rich Client.

I can see SAP Icons as a font option in the formatting menu, but they just don't display properly on the page.

thanks

Keith

Hi Keith,

tried it on a test machine and worked fine following the instruction (on the server had to change fontalias.xml only in ..\win64_x64\fonts).
Did you restart the tomcat ?

regards Thomas

HI Thomas,

Is it possible to create our own Universe using Business objects Open connectivity driver. We are looking for server metrics data (CPU Usuage,RAM Used,Open connections etc)

Thanks in advance

Sorry Thomas What is required from my side. Well the universe that is currently being supplied does not have Server details,so my question was can we access the CMS DB via CMS DB Driver and include the Server Table(essentially tables that have server related information).

Is that possible ?

Thanks in advance

Thanks once again Thomas for your response on this. Where Can i find this Sample-QT-Properties with Filter (Server)  is it in the sample universe provided here or I have to look for it in any other place.

Thanks in advance

Hi Thomas, that is really great to have this, it is extremely useful I think! We are monitoring and reporting our customers' license usage with the help of the information in the repository, so far with a third party solution I would like to replace. There is one thing I tried to get, but I could not figure out how to. Disabled users. Aliases (we use WinAD and enterprise)  and if they are disabled. We need to report all users and highlight disabled ones, which do not use license but we always have to keep them for some time. Is there a way to build a query which returns all users and whether they have a disabled alias? Many thanks in advance

´Hi All,

The driver causes always the following warning message on the BO server. Any idea about that?

"Server Intelligence Agent: server XXX .WebIntelligenceProcessingServer is logging excessively.  Use -traceconsole to investigate."

Thanks,

Emre.

We encountered an issue with "Group_To_Members" relationship (in Relationships To-L1 folder). I created a report that extracted all users belonging to every usergroup, through "Group_To_Memebers" relationship. But the query did not retrieve all si_name properties of the users, but gave only a partial result. Instead I correctly obtained all users si_id (given from "Group_To_Members" dimension). I would to attach an image as instance but I have not permissions. Any suggestions?

Hi Thomas 

First of all a huge thank you for this awesome work!! 

Is it or will it be possible to list all Webi Documents with freehand SQL?

Best Regards, 

Guillaume

Hi All,

I am trying to to add objects to the CMS Universe which provide information about the Data Security Profiles (DSP) and Business Security Profiles (BSP) we put on a Universe.

So far, I was able to create objects displaying their ID's (relationships((Properties.SI_SL_BSPS)), related Universes (relationships(Properties.SI_SL_BSP_TO_UNIVERSES)) and related User Groups (relationships(Properties.SI_SL_PRINCIPALS)). I was able to find these through the Query Builder.

I was hoping to find some more details about the DSP's and BSP's, for example about the defined ROWS or Granted Views.

Does anyone know if this is possible? And if so, how?

Kind Regards,

Martijn

Hey Thomas,

thanks for the great work!

do you know if I can somehow create something like a derived dimension based on for example the schedule_type?

I tried to create a dimension "schedule type text" where I iterated over schedule_type with a case to set for example 0 to "Once".

Unfortunately, this did not work. Do you know a solution?

Best regards

Philip

Hi Thomas,

is contemplated in future enhancements the possibility of using IsAllowed function in "BI Platform CMS system database" universe? Today if I want to extract which universes are granted to a specific user , I have to extract them with query builder using "IsAllowed (<UserID>, 3 for View general right>)".

Thanks in advance.

Angelica

Hi Thomas, I created a custom linked universe to explore CMS DB, as you suggested in I added new dimension "Descrizione_Utente" obtained from "SI_DESCRIPTION" properties extracted with query builder for "user" kind object. I used a report with two queries: - the first extracts all users - the second filters only a certain kind of users from the list obtained by the first query. I tried to add my dimension "Descrizione_Utente"in both queries, but it works fine only in the second query. In the first query the refresh returns this java error: IES 10901 (in attachment all screenshots). If I add in this query the id of a single user as filter, it runs correctly. Why is it necessary to filter also for "si_id" dimension and is it not enough to filter for kind equal to user only?

Thanks as ever!

Angelica

Good morning Thomas, is there a way to filter only certain Acls from universe? I made a query who extracts all accesses (Access dimension) related to usergroups (PrincipalName dimension) on any .unv or .unx of my Sap BI 4.0 environment (as you can see in attached screenshot). I would to filter this query also for: "Access" different from pattern %xxxx% , where <xxxx> is a specific ACL who denies access to Everyone, but I can't add the "Access" dimension in Query Filter section.  Thanks in advance!

Angelica

Hi, does somebody know if somewhere in the CMS, and so retrievable through this universe, the values can be found from WEBI-filters.

Example , suppose you have an eFashion WEBI-report-query

and in the filter of the query, you have : State Equal "California"

In this example, I would like to search for all WEBI-Document in the repository, in which a filter is used on object "State", and where the value "California" is used

Mane thanks for the help

Eddy

I have another question :

is it possible to get a list of WEBI-document where a certain universe-object is used ?

I gave it a try but could not find a solution. All info welcome

Thanks, Eddy

Hi,

I'm getting the  "Specified RDBMS is invalid..." error message when trying to create a report based off of CMS DB universe and after checking in DataAccess\Connection server folder  , i do not see the CMS folder listed and i also dont see the CMS System Database when im trying to create new connection. What should i do to have the CMS data access driver installed? Thanks in advance!

Thank you, Thomas!

Can we get the folder path from query builder when we query to get list of reports from a folder which has multiple sub-folders?

Hi 

I am working on some reports on CMS data access, using SAP universe (BI Repository Analysis universe/BI Platform CMS system database)

But getting Error message: Specified RDBMS is invalid : CMS. Same error message in IDT connection level also.   

Is there any easy-way to fix this error and access SAP universe (BI Repository Analysis universe/BI Platform CMS system database). 

Hi Guys,

I need to get the parameter list of the objects/reports (as a report).  Is it in a way over this CMS Driver possible? In Audit DB It seems, I can get the entire generated query but not the parameters..

Emre.

Hi Emre,
guess this is a similar question like the one adressed in this Discussion
regards Thomas

hi

download link is not working. Can you please enable it .

Hi Thomas ,

Fantastic write up and follow ups .

Can we know what are the functions supported for CMS database reporting . We are using SQL server and trying to get substring from "Name" object but failing .

Thank you

Sateesh

Hello Thomas and Thank you very much for creating and maintaining this blog. Personally, I feel this is one of the best features that I've seen in a while! I'm looking forward to the next version....

I do have one question, is it possible to create a query that can display all elements of a universe (example: Classes, Objects, Object Details, etc.)?

Regards,

Jon

Hi, Is it possible to mix CMS Univers with Audit univers ? to get more complete Audit reports !!

like the list of user group/user/number of refresh/documents/path

I tried to do that but no success  In IDT I couldn’t mix the two univers Audit and CMS

We've applied the latest patch update 5 on 4.2 SP3 and this driver appears to have been deleted/missed off the build. Has anyone else applied a patch and found the same issue.

Thanks

Hi

I'm trying to get the recently opened documents, In query builder the query is as follows 

SELECT SI_RECENT_DOCUMENTS
FROM CI_SYSTEMOBJECTS WHERE SI_KIND='USER' AND SI_NAME= 'myname'

anyone have idea how this can be done ?

Hi Thomas,

Thanks for this document.

What is the function to retrieve a specific array value inside a property. For example.  if I want to retrieve SI_FOLDER_NAME1 from below image, should I create a dimension

 Properties.SI_Path.SI_FOLDER_NAME1. I tried it but and returns blank value. Please suggest if there is any specific function to retrieve any specific property array value.

Regards,

Animesh Kumar

Hi

where do I see list of functions the driver support, for example concatenation 

Thanks

Hi,

We are getting error : Table or view does not exist.

Upon checking in the .dfx in IDT it seems there is no "Properties" table in the CMS database.

We have only the following tables in the BI 4.2 sp3 p6 CMS database:

CMS_ALIASES7
CMS_IDNUMBERS7
CMS_INFOOBJECTS7
CMS_LOCKS7
CMS_RELATIONS7
CMS_SESSIONS7
CMS_VERSIONINFO
CMS_CCFRONTIER7
CMS_FRONTIER7
CMS_ROOTFRONTIER7

.

We have upgraded from BI 4.0 sp6 p4 and we are currently on BI 4.2 sp3 p6.

Is there any steps to be done after upgradation to 4.2 sp3 to get the "Properties" table ?

Thanks

Orion

Is there a simple way to get a list of Users, UserGroups AND the UserGroups Description?  I am able to get a list of UserGroups and the UserGroups Description using the Technical Properties objects and then using filters at the report level to get SI_DESCRIPTION.  However, when I attempt to create single a query that shows Users with there UserGroups and the Group Description it comes up with a query error.

I have also found that when I create a query using the Technical Properties and attempt to create a query filter on PropertyName to select SI_DESCRIPTION, I must use the Equals To comparison. In List yields no results.  The problem with this is that the CUID and NAME come back blank when using a query filter on PropertyName.

@Thomas Jentsch

Thanks for sharing this information. 

We have few requirements. Does new CMS will provide with any solution?

1. We use Analysis for Office workbooks & Lumira documents. Most of these documents are created by users, consuming BEX reports. To do impact analysis for any BEX changes to final AFO workbook or Lumira, we need to have meta=data or link between AFO workbook to BEX and Lumira to BEX. 
   Does CMS database store this meta-data? In case of WEBI, we can get the link between WEBI Report to BEX using SI_WEBI_DOC_PROPERTIES (extract from XML). We are not able to see that for AFO (Our current version is BO 4.1, want to check if 4.2 will solve this)
2. WEBI reports with multiple tables & datasource - we are finding very hard to get this meta-data link between WEBI reports to multiple BEX. Is there any solution for this?
   
   Thanks !!
   
   

Hi Thomas. We are on BI 4.2 SP3.2, and we started using this new universe some weeks back. But since a few days it is not working anymore on our PRD-environment. The connection, when testing through IDT, is still working.

But when refreshing a very small simple test-report which worked before, we got the error

The following database error occurred: (CS) "Unexpected behavior : while trying to invoke the method com.sap.connectivity.cs.java.drivers.sdk.sqlparser.IColumnDefinition.getResultFieldDef() of a null object loaded from local variable 'resultColumnDef'" . For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)

I searched on several of the strings of above error-message, but I cannot find anything that would lead me to a solution.

Have you any idea ?

Thanks a lot.

Hi Thomas.

In 4.2 Sp3, if I refresh a webi report with more than one query, I get this error:

If I refresh one query at a time all runs fine.

Any idea?

Angelica

Hi Thomas,

We are trying to reproduce a CMS Query to retrive the webi documents with prompts

SELECT SI_ID, SI_KIND, SI_NAME, SI_PROCESSINFO.SI_HAS_PROMPTS,

SI_PROCESSINFO.SI_WEBI_PROMPTS, SI_PROCESSINFO.SI_FILES,
SI_PROCESSINFO.SI_PROMPTS FROM CI_INFOOBJECTS
WHERE SI_KIND = 'WEBI' and SI_INSTANCE = 0 and
SI_PROCESSINFO.SI_HAS_PROMPTS=1

Theroretically query seems to be possible using CMS Driver based universe but the query does not provide any row (appears empty) despite that the when CMS query is executed on 

querybuyilder dozens of rows are returned.

Any idea?

Hi Thomas, I see in planned activities "Git Hub repository" as Topic with this description "We plan to create an open source project on the SAP Git Hub platform to collaborate on Universes and Web Intelligence documents". Are there news about the start of this activity? I created N reports that I would to share with other people to help us each other.

Thanks in advance!

Angelica

Hi Thomas, I would to extract additional informations about connections, as "service name", "user name", "password" that we inserted when we created all connections in IDT.

Is there a property that can give me these information from cms repository?

Angelica

Thomas,

Is there a way to access User Attributes that are mapped to Windows AD or LDAP attributes?  I created a few User Attributes via the CMC in the User Attribute Management area but I have not figured out how to access these values via the BI universe.  I tried defining a Dimension object using Properties.si_[attributename] and defining a Long text object using text(Properties.si_[attributename],"1000") but the values appear as null.  I even tried using @VARIABLE('SI_[ATTRIBUTENAME]') but still null.

Any thoughts?

Thanks!

Mickey

Hi Thomas,

I just imported the sample universe and reports , when i try to run the sample reports they are working fine in Launch pad ,but when i try to change the prompt values am getting error "open connectivity driver error"  In IDT if i test the connection it is showing Test successful but when i try to parse the objects in IDT getting the error "No query filter defined".

Could you please help me with the next steps to be followed or checked.

Regards,

Vijetha S

Thomas, me again... trying to identify the "VIP" of reports in our deployment, 1) those that have been viewed recently, 2) modified recently, 3) large in size, 4) scheduled, 5) number of times viewed, 6) number of times modified, 7) days in production, etc. Anyway-

I'm working on #4, scheduled reports, and when I open the 'Scheduling' report from the samples pack, I see the 'Recurring' tab. When I refresh the report, I choose Ancestor of 18 and 23 to get personal and public folders. I don't put any date criteria in. On the Recurring tab, there's only a few reports. If I go into CMC, Instance Manager, and do a Find on those with a status of Recurring, I get 471 items. It's proving very difficult to find this list of 471 items within a Report from the CMS driver.... Am I helpless? Or is it expected to be this difficult? 

I found one report example where it is scheduled, and status is currently Recurring (per CMC Instance Manager), but in the Sample Scheduling\Recurring report, it is not being listed because the New Job ID is NULL_VALUE for this report, and the Recurring page filters out any reports where New Job ID is not equal to NULL_VALUE?

Hi Thomas, 

 I have been following this wiki for some time now. Thanks for publishing it.

We have been trying to get information about : Derive a query from the CMS DB driver Universe which gives the list of reports a user has "view" access ( reports which user can see in BI launchpad) .   Is it possible/workaround  using this universe ?

Something similar to  query builder  SQL query : Select TOP 10 SI_ID, SI_NAME, SI_CUID, SI_KIND From CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS Where SI_KIND='webi' And IsAllowed(1067216, 3)  . But this doesn't provide list of reports from inbox and favorites. So, we want to derive this information from the new CMS universe. Can you please let me know if this is possible using new CMS universe.

Thanks,

Srinivas Perumandla

Hi,

Has anyone had any luck retrieving the Who, When , Where and What from default Publication information. The bundled BI on Bi Publication report is failing unfortunately.

I have tried using the technical properties class but nothing uselful exposed sadly.

Thanks.

When I try refreshing the query I get the error message below.

The following database error occurred: (CS) "Unexpected behavior : while trying to invoke the method com.sap.connectivity.cs.java.drivers.cms.data.Relationship.getIds(com.crystaldecisions.sdk.occa.infostore.IInfoObject, java.util.Set) of a null object returned from java.util.Map.get(java.lang.Object)" . For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901) (Error: INF )

If I remove L1 objects Name and Kind it works but limited info.

Hi. I'm looking for an example to produce a list of WEBI-Documents which are build on a certain .unv or .unx universe. I found a way to produce it, with 2 queries : one of the .unv universes, one on all the WEBI-Docs. And then an Input-control of the universe-ID on the data-set of the WEBI-docs. I had to do it this way as apparently it's not possible to use the "webi-to-unv" objects as query-filters

But I hope there is a better way to accomplish this. Has somebody accidently a good example ?

Many thanks

Hi Thomas,

Its really a great work, which make most of the admin work easy. am following this post from quite a long time now.

We are using Multitenancy Manager in our organization as we have more number of tenants.

I would like to know from any way Can we pull the Tenant wise data in to the report using this Universe.

Like No: of reports, universes, users for each Tenant.

Hi Thomas! Last week we upgraded ou sandbox system from 4.2 Sp3 to Sp4 Fp2. Now some query filters and security dimensions have problems. SP4 installation (without FPs) gives the same issues. Below the details:

1. Query filters “Matches pattern” and “Different from pattern” don’t work more and return a generic “OpenConnectivity driver error : Exception parsing query” error
2. Security dimensions “PrincipalName” and “Access” don’t work more. They don’t return an error executing queries but don’t extract more any result for whatever kind of object

I am getting the usual "Specified RDBMS is invalid : SAP BI platform CMS system database" error.
I am already familiar with  "2405568 - When install the BI 4.2 SP03...". That only applies if you have a "working environment" from the same patch.
Since we just upgraded from SAP BusinessObjects BI Platform 4.1 Support Pack 5 Patch 3 to SAP BusinessObjects BI Platform 4.2 Support Pack 3 Patch 8,
we do not have a working source to copy from.

I am missing the folder D:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\cms

How could the CMS system database driver be missing if it is installed by default? 
Since the install for both the Server and Client do not have any configurable options to choose to install drivers or not, how do I get the missing
driver installed?

Brian, thank you for the reply.

But no, I was not presented a "Custom/Expand" opportunity. I captured every screen as part of the 4.2 SP3 install, and it went from:
WinRAR self-extracting archive to Check Prerequisites to the Installation Wizard Welcome screen to License Agreement screen to
New License Key Agreement screen to Existing CMS Deployment screen to Select Installation Mode (Standard vs. Phase-wise),
I chose Standard, next was the Web Application Deployment screen (Deploy now vs. later), I chose now, and then the 
Start Installing screen came up...and that was about it.

This was also the case for the Server install, the Client install on the server, and the Patch 8 installation. 

Besides choosing the Installation Mode and Web Application choice, there were no other opportunities to customize or expand 
any of the the installation components. 

Here are the exact SAP install files used:
BIPLATS4203_0-80001044_P1.EXE
BIPLATSVR4203P_8-80001044.EXE
BIPLATCLNT4203_0-70000090.EXE
BIPLATCLNT4203P_8-70000090.EXE

Again, thank you your reply.
Just to make sure it is clarified - the options were not Standard vs. Custom, they were Standard vs. Phase-wise. Here is the exact text from the SAP
installation:
"Standard Installation: Installation is performed in single-phase."
"Phase-wise Installation: Installation is performed in two phases - caching and Installation after caching. During Caching the system downtime is eliminated.
Installation after caching is the actual installation process where you experience downtime."

To me, Phase-wise would not have given an option to review components. If that was the path I should have taken, the help text was way off.

Brian - thank you. I will dig some more.

Hello, I am getting error message "Access to share expired. Share is no longer available" when trying to follow Download link in "Get started" section above.

Full URL is: https://mdocs.sap.com/mcm/public/v1/open?shr=EqWHuiXKyPlBYsHQUM4qjjwj3BRxNmiZAFLYQuzFqFE

I did not find anyone else reporting the same problem on this page.

Thank you in advance for your help!

Does anyone know if there is support for the bira universe and sample webi reports on 4.2 SP4?  Looks like the table names have changed from SP3 to SP4?  If anyone has any insight to this topic is appreciated. 

This link on this page has expired fyi...

Download the content (universe, Web Intelligence samples and videos)

Hi

I am trying to determine the recurrence details of a Publication Schedule. I have selected on Kind=Publication which isn't in the drop down of Kind types.

I have then used all the objects in the Scheduling class but none of them seem to be the start and end time set in the Recurrence section of a publication.

Are these properties exposed in the Universe ?

I tried using the technical properties to see if they are held in the property bag without any luck.

Thanks

Hi Thomas,

I review your earlier post regarding the flattening of hierarchy in CMS database.  We upgraded to BI4.2 SP3.8 and the my CMS queries are failing in 2 areas.  1) FolderPath returns blank.  Thank you for your post.  I can resolve this.  2) Query users and groups.  My query the CMS database and returns the number of users in each group for each folder in the hierarchy, it is failing due to the flattening of the hierarchy.  I can expand on user to group to folder relationship in BI4.2 SP3.8?  Agiain, very informative and help.  Thank you.

regards

D. "yome"

Hi all.

is there accidently somebody who has an example to produce a list of all report-schedules for a particular ServerGroup ?

Many thanks,

Eddy

Hi all, I can get the universe and path by linking using Folder Name but is there a way to get the Description of the universe?

Hi all,

does anyone know if there's a possibility to change the language of the results aquired using the new ACL-query-functionality?

Thanks in advance and best regards

Philip

Hi all, hi Thomas,

it is really great to have this new data access driver for BI 4.2 SP3 - it is extremely useful.

I'm just about to extend it by creating a custom linked universe to explore CMS DB, as you suggested.

At the moment I would like to add a dimension object displaying the SI_MAIL_ADDRESSES in Scheduling Info - SI_DESTINATIONS - ... Unfortunately I don't get rid of that. Could you please let me know if that's possible, and if yes, how to do that?

Thanks in advance
Norbert

All,

Thread is very helpful.  Can anyone point me to a resource that explains the universe in more detail?  Not sure what the different levels represent.

Hello

I have this query in Query builder

SELECT SI_ML_NAME  FROM CI_INFOOBJECTS WHERE SI_KIND = 'Webi' and SI_CUID ='AWL29i.r4ydCgaujjTTX.7c'

The result is array of all available translation of the report name

 I would like to convert this to CMS universe and to be able to retrieve only one language at a time for example ES_ES

How can I do it ????

Thanks

Dror

Has anyone experienced an issue attempting to do a Query Filter on 'Name' in which the search value contain parenthesis "("?  I wrote a simple request to get UserGroups and the Members of the group with a filter on the Group Name for a group that has parenthesis in the name.  It runs but brings back no records.

SELECT

Properties.si_cuid,
int(Properties.si_id),
Properties.si_name,
Properties.si_kind,
relationships(Properties.si_group_members),
Level1.si_cuid,
int(Level1.si_id),
Level1.si_name,
Level1.si_kind
FROM
Properties,
Properties Level1
WHERE
( Properties.join=Level1.join )
AND
(
Properties.si_kind = 'UserGroup'
AND
Properties.si_name = 'Group Name (Sample)'
)

Hi, I tried to execute a sample query from the Universe "Sample-Members-to-Group" and encountered the following error. Please let me know if anyone figured it out, i need to find all the users in each user group. 

Syntax error in SQL query : [line 1:265 no viable alternative at input ')'][line 1:265 missing EOF at ')']

Error:
Exception parsing query: SELECT
int(Properties.si_id),
Properties.si_name,
Properties.si_kind,
relationships(Properties.si_usergroups),
int(Level1.si_id),
Level1.si_name,
Level1.si_kind
FROM
Properties,
Properties Level1
WHERE
( Properties.join=Level1.join )
AND ( ( Properties.si_kind ) )
AND
Properties.si_kind IN ( 'User' )

Thanks

Arun

Hi all! If someone has issue with empty data for some dimension  (for example with security dimensions) from SP4 to higher, now is available offical Sap Note "2578194 - Some objects do not display data while creating a WebI document based on CMS Database" wihich is under investigation from development team.

Angelica

Hi, does somebody of the SAP-Persons know if the BIAR available after installing BI 4.2 SP5, contains the latest versions of the Universe and the sample WEBI-Reports ?

Thanks,

Eddy

Has anyone else encountered issues with the CMS database driver after patching BOB 42, SP3 with SP5?  After applying the SP5 patch, I am not able to run reports using the BI Platform CMS System Database universe.

Michael,

     This is a know issue with BI 4.2 SP3 Patch 4 or higher.  There are KB2405568 and KB2505827 that explains how to install the driver files manually from working system.

Ajay

Michael,

       BI 4.2 SP5 the install should be work fine now but there is a small issue running certain queries.  I discovered this issue during the SP5 beta testing and received manual fix from the team.  I was also told the final fix should be Patch 1 for SP05, which is out now.

Ajay

Thomas,

I did some experimenting after updating the BI on BI contents in my SP5 install and discovered there is an issue running Webi documents that use the BI platform CMS system database universe when CORBA SSL is configured.  Is there a way to configure CORBA SSL for the CMS Database Driver?  The following is the error message received when CORBA SSL is configured and I attempt to run a Webi document using the BI platform CMS system database universe.  If i remove the CORBA SSL configuration the same Webi document runs fine.

The following database error occurred: (CS) "OpenConnectivity driver error : Unable to find servers in CMS [fully qualified server name]:6400 and cluster @[fully qualified server name]:6400 with kind cms and service null. All such servers could be down or disabled by the administrator. (FWM 01014)" . For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901) (Error: INF )

Thanks ~ Mickey

Hi,

has anyone ever tried to report on the email recipients of scheduled reports, and also the email recipients of schedule notifcation emails?

I can see that there is a common objects of 'kind' that is called 'notifcationemail' or similar - do the associated CUIDs for these objects help in this case?

thanks

Keith

I downloaded the content from the link above and installed to ny system from the lcmbiars.  Then I found the lcmbiar file in the samples folder for my 4.2 SP7 installation.  For the latest version do I need to install the version I got from my Samples folder?  Thanks!!

Rick

Hi Thomas, hi all

I installed latest release of Sap BI 4.2 Sp7 full but found a bug: "Publication" property kind is missed. In previous release (until Sp4 in my experience) it was possible to search an object filtered by kind as publication selecting it by "values from list". From Sp7 instead it is necessary to insert manually kind='Publication' as constant.

Yes Thomas, you have right, as I tested and demostrated in the second attached image, if I insert manually 'publication' as constant value it works and I obtain all publication objects in query panel preview. I posted this comment as advice for all members of this article to help them working with this kind of objects. Thank you very much for your confirm!

Hi Thomas,

This feature is like a GEM in a treasure chest ! thanks for unlocking it for us 

I am trying to build a webi report in BI 4.2 Sp3 patch 8 to find out Crystal report Instance details like SI_PROCESSINFO.SI_PROMPTS,SI_NEXTRUNTIME,SI_NAME,SI_ID,SI_SCHEDULEINFO.SI_DESTINATIONS.SI_MAIL_ADDRESSES

of which I am not able to figure out a way to fetch values inside SI_PROCESSINFO and SI_SCHEDULEINFO which fall under technical category.

I can affirm that technical query property works like a charm for displaying block/bag like SI_EXTENDED_PROCESSINFO which exists in main property. However is there a way to fetch block/bag contents inside SI_PROCESSINFO and SI_SCHEDULEINFO 

Example query:

SELECT
Property(Properties.technical),
PropertyValueText(Properties.si_processinginfo.technical,"300")
FROM
Properties
WHERE
Properties.si_cuid = 'FuGfMF34agsANlcAAACnIWsUAFBWuymJ'

The query executes but returns null 

-Guru

Good morning Thomas,

today I found other issue with Sp7 full release, that there was not in Sp4. When I extract all schedule objects (all objects with property SI_SCHEDULING=1) I obtain 5000 max values. But in my system there are 20403 total schedules. I created a custom filter "TOP 200000" to avoid any kind of numeral limitation, but it does not work more.

If I search with query builder, instead:

select top 200000 si_id
from ci_infoobjects
where SI_INSTANCE=1

I obtain correctly 20403 objects.

Has anyone been able to modify the CMS universe to pull data related to Analysis for OLAP documents (workspaces?)  Specifically, I'm trying to pull the name of the BEx query used by the workspace (kind = MDAnalysis.)

Using this query in query builder I'm able to get the data, so I know it's available by query.

SELECT SI_OWNER, SI_NAME, SI_CUID, SI_DATASOURCES_URIS, SI_CREATION_TIME, SI_UPDATE_TS from ci_infoobjects WHERE descendants("si_name='Folder Hierarchy'", "SI_PARENTID = 18") AND si_kind = 'MDAnalysis' and SI_DATASOURCES_URIS is not null order by SI_UPDATE_TS DESC 

However, I'm not sure how to get the CMS universe to fulfill this request.

Following, the how-to instruction published here (BIRA universe: 01 - add simple objects) I was able to create a 'simple object' for the BEx query field SI_DATASOURCES_URIS.

When adding it to a CMS universe query that pulls workspaces the SI_DATASOURCES_URIS is empty.  I think I need to build a relationship object between workspace and the SI_DATASOURCES_URIS object (similar to what is already provided for webi type documents in the universe.)  The process for doing this is not clear to me.

Can anyone help with this?  Thank you,

Mike

Hi,

Apologies if this has been asked before. I've just downloaded and implemented this into our platform (4.2 SP6 patch 6) and I'm looking forward to exploring.

One thing I've noticed is that the template universe generated contains quite a few objects from the 'Properties' table, but when I look at the universe in IDT, or use the connection in Universe Designer, I can only see 4 columns listed... Is there a way of seeing all the columns in this table?

Basically, I'm looking to be able report on whether reports are scheduled, and if they are, what email addresses and file locations are scheduled out to?

Thanks

Paul

I want to let everyone know about an issue I found, not with the CMS Driver or the universe, but with the CMS objects properties which the CMS driver and universe report from.

We are running BOB 4.2, SP7, Patch 02.  We have a mix of old UNV universes and new UNX universes.  I have found if I have a Webi document that uses a UNV and a UNX, the SI_DSL_UNIVERSE property, which should contain the SI_IDs of the UNX universes used by the document, will be empty on the Webi document object in the destination CMS when the document is promoted.  In addition, the SI_SL_DOCUMENTS property for the UNX universe used by the Webi document does not contain the Webi document SI_ID in the destination CMS.

Has anyone else encountered this issue?  Is this fixed in a Patch for SP7?

@Thomas Jentsch - Would you be able to look into this and perhaps help get this issue raised in priority?

I have a ticket open with SAP (603060 / 2019).  I am getting the impression SAP is not going to fix this issue.  You need to understand this problem makes it impossible to get accurate information using the CMS Data Access Driver and universe.

Thank you!