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

Updating Excel File in Data Module

Started by AndreasM, 12 Oct 2022 04:09:38 PM

Previous topic - Next topic

AndreasM

I'm running into a problem as I'm working on expanding an Excel file used in a Data Module. It's only a temporary proof of concept before we start development of the actual data module, so I won't have to deal with this again soon enough, but I keep having a problem where my Data Module isn't updating with new columns that I'm adding to my tables. I add in a new column, save and upload the file, and click on "Refresh Members" on the associated table in my Data Module, yet the new column won't appear. I've even started making a new Module to show that the data exists in the uploaded file.

Does any one know of a way to refresh the data loading in from an Excel source after uploading an updated file? I've had to rebuild this Data Module from scratch multiple times now and I'd like to avoid copy/pasting these 40 formulas again.

bus_pass_man

When you expand the sources pane (press the button on the far left) do you see the file and the new columns?

Drag the new columns into the module.   In older releases you will need to drag the table in to add them.

Members are not columns.  They are the values of a column.

AndreasM

I do not. When I go to make a new module, the new column pulls in just fine, but it won't appear anywhere in the old one. When I select to add more tables from the existing source, I can see the new column, but there's no option to reload the data that I can see anywhere.

MFGF

Quote from: AndreasMSchick on 13 Oct 2022 08:22:39 AM
I do not. When I go to make a new module, the new column pulls in just fine, but it won't appear anywhere in the old one. When I select to add more tables from the existing source, I can see the new column, but there's no option to reload the data that I can see anywhere.

Hi,

Just to clarify - normally you see the Data Module pane on the left (with the uploaded file and columns), but to the left of that is another collapsed pane which can be expanded by pressing the "Source view" button in the top left corner. Are you definitely looking in the expanded Sources pane and still not seeing the new columns displayed? If you don't see them, have you made sure you have re-uploaded the file using the same name to the same location in CA?

Cheers!

MF.
Meep!

AndreasM

Ah ha! I did not know about the second pane. Thank you so much, that solved the issue!