BMC Communities : Thread List - BSM Dashboards and Analytics

BMC Dashboards database access

forums@developer.bmc.com — Fri, 20 Nov 2009 18:31:35 GMT

I'm attempting to configure a Remedy data source for BMC Dashboards 2.5.01 but am getting a timeout error even though I can connect to the database directly via SQLCreator and as a data source for the ITSM Universer in BMC Analytics 2.5.01.

The databse is an Oracle 10gR2 logical standby. This database prevents writing to any table.

Does Dashboards require write access to a Remedy database data source?

Analytics 2.5.01 Windows AD Login Error

forums@developer.bmc.com — Mon, 02 Nov 2009 22:09:59 GMT

Hi. I need some help on Windows AD user account.

I created a new user account using Authentication Type of Windows AD, but when I used the new user id to log in, I got the following error:

Account Information Not Recognized: Active Directory Authentication failed to log you on. Please contact your system administrator to make sure you are a member of a valid mapped group and try again. If you are not a member of the default domain, enter your user name as UserName@DNS_DomainName, and then try again. (FWM 00006)

Enter your user information and click Log On.

(If you are unsure of your account information, contact your system administrator.)

I didn't have problem to create the id and also was able to import the full name and email address after the account was created.

Thanks,

Eric

My (brief) top tips for a BMC Analytics for BSM 2.5.01 install

jim_wilson@bmc.com — Fri, 05 Jun 2009 15:37:24 GMT

Here is my brief "top tips" list for preparing for a BMC Analytics for BSM 2.5.01 new install

· For BMC Analytics for BSM 2.5.01, the EPD downloads are about 3.2GB, so you may want to acquire physical media before you start.

· The install planning involves identifying information to access ARSystem and it's underlying database (host name. port, userid, password)

· If you are using W2K3 Server, the FixPack install requires a Microsoft Hot Fix as pre-req: http://support.microsoft.com/kb/925336.

· Make sure you keep a note of the CMS database details that you use during install of BOEXI.

· Make sure you run CCM, CMC, InfoView when BOEXI install completes before starting Analytics install.

· Analytics install requires 3 connections:

- To the BOEXI installed CMS (to import the Analytics universe and report definitions)

- To the AR System as an administrator to import a Form definition and work flow for the Fiscal Calendar

- To the AR System database to install database objects used by analytics (Tables, views, functions and procedures)

· Make sure you complete all the "Verifying the installation" steps:

- Creating users on the SAP BusinessObjects Enterprise server

- Configuring universe parameters (Always: import, configure, save, export)

- Loading the ANA_FISCAL_CALENDAR

- Refresh the reports

LDAP, Oracle and BusinessObjects

forums@developer.bmc.com — Wed, 18 Nov 2009 21:06:07 GMT

Hello all, I'm looking for some advice on the best way to solve the following issue.

First, the environment:

Remedy 7.1 on an Oracle 10gR2 database (case sensitive)
BusinessObjects XI 3.1 FP1.3
LDAP (Novell eDirectory) is configured for AREA LDAP and in BOXI
The Remedy Login ID field in CTM:People in Remedy is all lowercase and the users have been trained to log in using all lowercase
The LDAP user name attribute (cn, in this case) contains all UPPERCASE user names

If a user logs into Remedy using all lowercase then AREA LDAP checks with LDAP, which is case-insensitive, and returns a positive result. Remedy then checks the log in information with the Remedy Login ID in CTM:People and finds a match and the user is logged in with all their expected rights.

However, if a user logs into Remedy using mixed case or call CAPS then AREA LDAP checks with LDAP, which is case-insensitive, and returns a positive result. Remedy then checks the log in information with the Remedy Login ID in CTM:People and does not find a match, due to Oracle being case-sensitive, and the user is logged in as a guest.

Hopefully everyone agrees with that.

Now, when LDAP was configured in BOXI and a group was mapped the users came into BOXI in ALL CAPS as this is how they are stored in LDAP. The problem is the row-level security predicate in the ITSM universe tries to compare the BOXI username, in ALL CAPS from LDAP, to the all lowecase Remedy Login ID in CTM:People and the report comes up blank.

This is an existing environment so changing all of the Remedy logins to all uppercase and training the users to log in that way is a non-starter. Likewise, the LDAP administrators won't be amenable to changing 40,000+ all UPPERCASE cn attributes to lowercase to match Remedy.

Other than having a BOXI administrator go in and manually update each BOXI user so that the usernames are all lowercase in BOXI, is there a solution for dealing with this?

Thanks

Creating a new Web Intelligence Document

forums@developer.bmc.com — Thu, 12 Nov 2009 12:23:55 GMT

Hi Everyone!!

I am new to Analytics ..

I have been playing around to understnd the stuff however i could not undertnad on how to make a new Web intelligence document with Charts like a bar chart just based on a Status...Im actully trying to replicate or little different than the one we have Analytics (2.5.00)->Incident managemnt ->I04 Resolution Time.......

I am able to create a report but I cant have Chart representaion of the same to add to this is how do i create a tab report???

Appreciate your Help!!

Regards,

Vishnu

Set MS Excel as Data Source on Dashboards

forums@developer.bmc.com — Wed, 28 Oct 2009 13:41:49 GMT

Set MS Excel as Data Source on Dashboards on a Sloaris \ Unix based machine. The excel files have been copied to /u01/app/boadmin/BMCDashboardsForBSM/CIS_4.5.0/apps/dil/excel_ds directory but we cannot see any excel files populated when we try and add a new data source for excel.

Has any one faced a similar issue ?

Incident, Change and Availability metrics on same report..

akhurana@westpac.com.au — Wed, 21 Oct 2009 11:38:48 GMT

Hi:

We are implementing BMC BSM solution stack including Remedy ITSM, SLM, Analytics, Impact solutions etc. We would now like to create an executive summary report showing following metrics on a single report:

Grouped by CI (likely to be some critical CIs like business services or applications or mainframe components etc..)

Number of Incidents with related CI (Total and individual severity 1, 2 and 3)

Number of Changes with related CI

% Availability of the CI based on status provied by SIM

Now, since Analytics can not pull data directly from SIM, I want to use SLM collector to pull SIM data into SLM tables and then use Analytics to correlate data between incidents, changes and availabiity data (provided from SIM via SLM).

Any suggestions, ideas, warnings ...

Regards,

Ashish

DASHBOARD custom datastore integration

forums@developer.bmc.com — Tue, 20 Oct 2009 23:36:20 GMT

Hi,

I have installed Dashboard on a customer site on dev system.

It is the 2.5.01.

Customer has only CMDB and drift.

meaning that all embeded report are not working.

I have create a custom datastore that is my ARS DB.

I have made some test on the BMC.CORE.ComputerSystem table

but when I try to set a filter by dataset ID it failed.

I haven't find any special document regarding the filter syntax.

I have made some test on the same table and I have select the field:

ISVIRTUAL

DATASETID

LASTSCANDATE

if I set a filter that select the "ISVIRTUAL" with filter set to =0

it works and sort the correct one without error on saving or preview.

when I try the same for DATASETID I have error on saving or preview.

I have try filter with ="BMC.IMPORT.TOPO" or BMC.IMPORT.TOPO or = 'BMC.IMPORT.TOPO'

don't know what to use.

any personn that have reports with ARS db directly are welcome to share it.

regards

gilles

Installation of BO and analytics with Oracle DB

forums@developer.bmc.com — Fri, 18 Sep 2009 19:59:16 GMT

Hi,

I have tryed to install the BO provide with analytics to use an Oracle db ( 10r2p4)

The customer DBA provide me an UTF8 db with characterset to american

AND

nls_lenght-semantics set to CHAR instead of byte ( default setting)

The db is on an AIX machine that have one instance and many schema on the same instance but the owner the dba provide me acces onnly one empty schema that will be used for the BO data.

I try to install the B0 XI on a windows machine.

when I got the page where the installer ask me to install the cms I provide the info to connect on the Oracle DB ( this info is the one that are on my Oracle client) I have the error bellow :

The root server reported an error Initialization Failure. (Reason: The index info object with id 0 does not match the type of the index already in the database. The requested property type is asciistring and the one in the database is invalid. The requested property size is 56 and the one in the database is 56.

any idea are welcome.

I have Use the BO 51035055_part1.exe that are RAR file from the EPD.

thanks

gilles

How to create a report including both a supported and a managed people relationship

mhurk@aegon.nl — Wed, 23 Sep 2009 13:31:51 GMT

I have the following case for which I want to create an analytics report.

Among our assets we have a large number of servers.

The operational management of these servers are outsourced to two IT partners.

Our business units manage these servers from an application perspective.

In our CMDB we translated this as follows:

we created a people organisation relationship (supported by) to the external organiations

In our CMDB we created a people organisation relationship (managed by) to the business unit.

Based on this information in the CMDB I want to create a report showing the CI name (server name), the business unit, and the external organisation

With my limited experience with analytics I generate a report with the attributes

CI name Supported by Managed By

Now my problem is that this report will provide me with two rows for the same CI name as follows:

CI Supported by Managed by

server1 unknown unit1

server1 external organiation1 unknown

Rather than 1 row for 1 CI (server) with both the managed by and supported by filled

Can someone explain to me how to create a report were both searched values are in one row?

export events and generate report

forums@developer.bmc.com — Mon, 22 Jun 2009 20:29:56 GMT

Hi All,

Can some one help me how to retrieve a report or a dump from all events generated in BEM (BMC event Manager) or to export all the events generated on the BMC Impact explorer into excel.