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...
------------------------------
Marc Reed
------------------------------
Original Message:
Sent: Fri September 22, 2023 04:59 AM
From: Philipp Hornung
Subject: Dashboard Selected sources appear as duplicates
Hi Marc,
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.
Best,
Philipp
------------------------------
Philipp Hornung
Business Intelligence Manager
Techniker Krankenkasse
Hamburg Germany
#IBMChampion
Original Message:
Sent: Fri September 22, 2023 02:27 AM
From: Marc Reed
Subject: Dashboard Selected sources appear as duplicates
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.
------------------------------
Marc Reed
Original Message:
Sent: Wed September 20, 2023 07:48 AM
From: Will Phillips
Subject: Dashboard Selected sources appear as duplicates
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?
Thanks!
------------------------------
Will Phillips
------------------------------