Panorama Business Intelligence

Your customer/company may want to get the effect shown by Analysis Services 2005 when browsing a dimension (see the picture below). He’ll want to see some properties of the members shown in the rows, along with the usual measures. Panorama  does not have this option in the GIU. The solution is this code:

Create Member CurrentCube.[Measures].[MyProperty] as
iif(IsLeaf([MyDimension].[MyHierarchy].CurrentMember),
[MyDimension].[MyHierarchy].CurrentMember.Properties(”MyProperty”),
Null)

(more…)

As the first company to offer a virtual appliance for BI I was asked how we differ from the newly released Virtual appliance released by Business Objects. The answer is very simple:

• The Panorama NovaView Virtual Appliance includes the full suite of BI applications; Analytics, reporting, scorecarding, dashboarding and visualization.
• The Business Objects VA only includes reporting
• The Panorama NovaView Virtual appliance does not have metadata layer such as Business Objects Universe and therefore can very easily plug and play into various existing OLAP solutions such as Microsoft SQL Analysis services and SAP BW

you can test drive our VA by downloading it from www.panorama.com/challenge

For several years now the industry has been talking about “BI for the masses,” and as more companies, large and small, realize the value and benefit of BI, deploying BI solutions quickly and easily becomes the order of day. One of the greatest impediments to deploying BI to users is the complexity of setting up and configuring BI solutions. The larger and more complex the organization, the greater the chance that deployments will get delayed, or sometimes stopped altogether.

To help overcome this hurdle, a number of vendors have introduced BI appliances. Some of these appliances are a combination of software and hardware (SAP NetWeaver Business Intelligence Accelerator for example) while others are virtual. In a recent Information Week article, http://www.informationweek.com/news/showArticle.jhtml?articleID=201805614, Business Objects announced their first virtual BI appliance. As solutions providers, I applaud the industry for the innovations made by vendors such as SAP and Business Objects for their appliances. Panorama is proud to have been the first BI vendor to deliver a virtual BI appliance last May. Since launch, we’ve distributed thousands of copies of our BI appliance for free.

In my opinion, to have a successful experience with virtual appliances, they should:

(more…)

This post is not about how to customize your Dashboard (well, not only about it). Its purpose is to say it loud: Customize your Dashboard!
When the executives of your company (Yeah, I guess you work in a company. Does someone building Bi Portal for himself?) see the customized gauges with their company logo on it, they’ll love it. No matter what these gauges will show them, you got their attention and their sympathy for the Dashboards site you made. Now, everything is easier. The bosses are in your hands.

Some technical stuff:

1. Follow this link to learn how to do this.
2. Do NOT start working before you backup your E-BI/KPI folder !
3. I recommend using Notepad++ or another good XML editor when writing in the XML files. Otherwise, you can mix the whole file and you’ll have to start all over again.