If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Two or more Excels in dashboard

Started by so10070, 11 Apr 2020 03:45:47 AM

Previous topic - Next topic

so10070

I have placed two Excels on one dashboard-tab with the following identical fields: [year], [sex], [total] and different fields as items (x-axis): [diversity] and [function].  I want to link the two Excels with one data player on the field [year] of - for example - the first Excel.  In some tabs the different Excels change there info with the data player of one Excel but not here.  What do I have to do so that this works fine?  :-[

so10070


MFGF

Quote from: so10070 on 11 Apr 2020 03:45:47 AM
I have placed two Excels on one dashboard-tab with the following identical fields: [year], [sex], [total] and different fields as items (x-axis): [diversity] and [function].  I want to link the two Excels with one data player on the field [year] of - for example - the first Excel.  In some tabs the different Excels change there info with the data player of one Excel but not here.  What do I have to do so that this works fine?  :-[

Hi,

Your best bet would be to bring both uploaded files into a data module and join them in the data module. Then base your dashboard on the data module.

Cheers!

MF.
Meep!

so10070