Hello list...
Environment:
ARSystem 8.1 Patch 002
ITSM 8.1 Patch 002
BSM Analytics for BSM 7.6.06 Patch 3
SAP Business Objects Business Intelligence Platform 4.0 SP5 Patch 3
ARSystem 8.1 Patch 002
ITSM 8.1 Patch 002
BSM Analytics for BSM 7.6.06 Patch 3
SAP Business Objects Business Intelligence Platform 4.0 SP5 Patch 3
I am wondering if anyone has experienced the same issue as below.
The issue I have is that I am logging into Analytics (actually BOXI) and trying to run Analytics reports. However, I do not get any data in any of the Analytics reports, even though my connection to the ITSM universe is valid and I am connecting to the underlying SQL database. I am logging into BOXI as "firstname.lastname" where "firstname.lastname" is the same as the LoginID in CTM:People (which must be the case when using Analytics in Multi-tenancy mode. Analytics uses the permissions associated with your entry in CTM:People in order to determine which customers you are allowed to report on (in multi-tenancy mode).
As mentioned above, the BMC Anaytics report definitions that are installed with Analytics query information from the ITSM universe based upon the currently logged in Business Objects userid.
The issue here is that all the Analytics reports that I saw EXPECT the Business Objects userid to be in the format of "[email protected]" as shown in the following highlighted (bolded) selection criteria in the Analytics report (Note: This is the subset of selection criteria that gets the permissions associated with the current user):
SELECT DISTINCT CTM1.COMPANY
FROM CTM_PEOPLE_PERMISSION_GROUPS CTM1
WHERE UPPER(REMEDY_LOGIN_ID) = UPPER(SUBSTRING(@VARIABLE('BOUSER'),0,CHARINDEX('@',@VARIABLE('BOUSER'))))
AND CTM1.COMPANY IS NOT NULL
AND ( CTM1.COMPANY = HPD.COMPANY
OR CTM1.COMPANY = HPD.CONTACT_COMPANY
OR CTM1.COMPANY = HPD.Direct_Contact_Company
OR CTM1.COMPANY = HPD.Assigned_Support_Company
OR CTM1.COMPANY = HPD.Owner_Support_Company) UNION SELECT DISTINCT CTM2.COMPANY
FROM CTM_PEOPLE_ORGANIZATION CTM2
WHERE
(SELECT 1
FROM CTM_PEOPLE_PERMISSION_GROUPS
WHERE UPPER(REMEDY_LOGIN_ID) = UPPER(SUBSTRING(@VARIABLE('BOUSER'),0,CHARINDEX('@',@VARIABLE('BOUSER'))))
AND PERMISSION_GROUP = 'Unrestricted Access') = 1
FROM CTM_PEOPLE_PERMISSION_GROUPS CTM1
WHERE UPPER(REMEDY_LOGIN_ID) = UPPER(SUBSTRING(@VARIABLE('BOUSER'),0,CHARINDEX('@',@VARIABLE('BOUSER'))))
AND CTM1.COMPANY IS NOT NULL
AND ( CTM1.COMPANY = HPD.COMPANY
OR CTM1.COMPANY = HPD.CONTACT_COMPANY
OR CTM1.COMPANY = HPD.Direct_Contact_Company
OR CTM1.COMPANY = HPD.Assigned_Support_Company
OR CTM1.COMPANY = HPD.Owner_Support_Company) UNION SELECT DISTINCT CTM2.COMPANY
FROM CTM_PEOPLE_ORGANIZATION CTM2
WHERE
(SELECT 1
FROM CTM_PEOPLE_PERMISSION_GROUPS
WHERE UPPER(REMEDY_LOGIN_ID) = UPPER(SUBSTRING(@VARIABLE('BOUSER'),0,CHARINDEX('@',@VARIABLE('BOUSER'))))
AND PERMISSION_GROUP = 'Unrestricted Access') = 1
(in the example above, @VARIABLE('BOUSER') returns the current login id of the BOXI user)
It is the string above....
UPPER(REMEDY_LOGIN_ID) = UPPER(SUBSTRING(@VARIABLE('BOUSER'),0,CHARINDEX('@',@VARIABLE('BOUSER'))))
that is embedded within all the Analytics reports that expects the "@" in the Business Objects userid. In our case, our userid (and Remedy userids) do not follow this convention. We follow "firstname.lastname". As a result, the query above returns NO results and my reports contain no data.
As soon as I change my BOXI userid to firstname.lastname@domainname , logout, and re-login into BOXI and run the report, the report runs just fine.
Has anyone else experienced this and/or can advise as to how to resolve ? (without modifying ALL Analytics reports).
Thanks..
Terry
