Change object name in the data cube

#1

We have created a data cube and build reports on it using SQL server tables. Would like to know , whether it is easy to change the table name from A to B in the data cube without impacting any reports. Table structure of A and B are same … only name change is required.
Case 1 : report.TableA change to report.TableB
Case 2: report.TableA change to report2.TableA
Case 3: report.TableA change to report2.TableB

Lastly we have build a report using sql server stored procedure. We had a extra letter in the name of the stored procedure. If I change the stored procedure name , whether it will require lot of efforts to change it?

We are new to Dundas and was told that we cannot change object name in Dundas which looks little weird for me. In all BI tools, changing the name is very simple.

1 Like
#2

Hi Suraj,

You can certainly change the table names, just make sure you update the data cubes after you make the changes in the data. Dundas BI has ‘re-wire’ capabilities which will help you with this re-mapping.

https://www.dundas.com/support/learning/documentation/cleanse-consolidate-modify-data/re-wire-the-data-flow

1 Like