Business Analytics Connect, learn and share with over 10000 users across the IBM Business Analytics. Join / Log in
I have built a dashboard in Cognos Analytics 11.1.7 and it works fine. I have deployed it to TEST then PROD, no issue. Works in all regions. The strange thing is that when I click Edit on the Dashboard and then click the sources icon in the upper left, it shows the package I built the dashboard on TWICE. Same exact name and same exact date. I am concerned that something is wrong, even though the dashboard works. I see this in all 3 regions (DEV,TEST,PROD) I am NOT using versioning in Framework.
Has anyone seen this? Is this something I should just ignore?
I guess this has been caused by some copy&paste action. You could try to "relink" both sources. If it doesn't help you could edit the specification and unify the sources here.
This will happen if you add a calculation within your dashboard.
For example, let's say I have 2 dashboards both based on the same 'Go Sales' data module.
In dashboard 1 you add a calculation. You then copy something from dashboard 1 to dashboard 2. You will now see a 'duplicate' Go Sales data source in dashboard 2. One of the data sources will have the calculation in it.
This sounds crazy, but think of this scenario...
I have 2 dashboards, both based on Go Sales.
In dashboard 1 I add a Variance calculation which is Sales - Returns. In dashboard 2 someone else adds a Variance calculation which is Sales - Costs.
We have two identically named variance calculations in two different dashboards.
We now copy a visualisation from one dashboard to the other... We cant simply ignore the second variance calculation, as that could mean visualisations actually changing meaning. We cant ignore it for the same reason.
Hence the duplication.
Thanks for your explaination. With your example: Why isn't the second calculation inserted as Variance_1 with the same data source? In reports something similar happens and I would expect something like that in dashboards, too.
Reports is a bit of a different paradigm, in that you add calculations into a query, and not into the datasource.
But I get the point - who knows why they went that route.
One thing I would say is that this is the only time a dashboard will apply filters to multiple data-sources. For example, if you have a data item in the filter bar then it will filter any visualisation regardless of which of the two data sources it uses.
Normally in dashboards, when you have multiple datasources, a filter only applies to the one datasource.
And given this behaviour - does it really matter if there are multiple links to the same data source...