1 of 1 people found this helpful
Replacing a Data Source
> Columns should be same
> Data Types should be same
> any fields in the original data source (for example, calculated fields, groups, sets, parameters, etc.), should also exist in the new data source. If not, then you may want to manually copy and paste these fields to the new data source before replacing the old one.
then only your replace works fine
hope this helps could you please explain what are the issues you are facing , if there any mismatch in the fields use the replace preferences
Kindly mark this answer as complete or helpful so that it will help others
Really thanks for you Kindly suggestion. I do a test on my local.
i tried to replace the workbook which contain all my calculation columns and objects with another excel file(just a copy of my raw excel file source ), the replace successfully, but I can see some fields's status become invalid, but the dashboard still working.... but when i do the same thing except the target data source is a big data table , the replace action failed.
so you are saying, if I need to change the data source from an excel file to a rdbms table, the only way I can do is copy and paste these fields to the new data source(a table)?
that means, I need to rename all the columns which I done in workbook again against to the table columns, then I need to paste all calculation column logic against to the tables, i
need to recreate all set creation as well?
No Need for creating agian runsun,
Connect to new data source so that in datasource pane you will see two data source go to the excel sources
drag all the calculation to new sheet , once you dragged all the calculations replace the datasources automatically your calculations will be copied to big data datasource
I tried to follow your guide, but looks like I can't find how to do it. forgive
the noob, can you do me a favor send a screenshot for how to (drag all the calculation to new sheet)?
below is my screenshot,
a is my original datasource, b is the new data source which don't contain one calculation fields in a. I want to do a test follow your guide.