While creating some scorecards for BI application, I faced a strange problem. That is, in that scorecard values and the indicators are not shown for some KPIs and others are ok.
The approach I used to create the scorecard is to Import SQL Server Analysis KPIs and after that add some KPIs from PerformancePoint. But the values and the indicators for the KPIs which are created by the PerformancePoint were not shown as shown in the below figure. PPSKPI is the KPI created in PerformancePoint.
I checked the procedure to create that scorecard and KPIs, and found it is ok. Finally I was able to find the reason for that issue. It is a very simple reason.
The reason is that the column names of those two KPI types are different.
For the KPIs which were imported from Analysis Services, those column names are Value and Goal and Status. KPIs which were created from PerformancePoint, those column names are Actual and Target.
When those column names were changed to Value and Goal and Status, the problem was solved...
Business Intelligence, Data Warehousing, OLAP Implementation, Reporting and many more...
Subscribe to:
Post Comments (Atom)
tablename_WriteToDataDestination: Mashup Exception Data Source Error Couldn't refresh the entity...
Once a Dataflow is created and published on Fabric, got the below error while refreshing the Dataflow. tablename_ WriteToDataDestination: M...
-
In SQL Report Subscription, you may want to send the report with the link and you can do it by selecting Include Link value. But some time...
-
In SQL Server Analysis Services Cube, there may be a situation where we need to combine two related fact tables. This kind of a situation ma...
-
When I tried to connect to a SharePoint URL in dashboard designer options, it prompt a message saying "The URL is not available, does n...
No comments:
Post a Comment