Hi All,

In Data Module, When I create a table using few data server tables, I want to add one more table to it later. I am not seeing option to add new table(s) once a view is created.

Please let me know if I am missing anything.

Thanks for inputs!

------------------------------
Buddhi Gupta
------------------------------

#CognosAnalyticswithWatson

Hi Buddhi

I have the same problem using 11.1.5

One way is to create a new view on top of the current view and also select the new table(s) and then change the Identifier on both views, so the new view gets the old views Identifier, this way the relations use the new view.

Another workaround I use is creating a new calculation(s) in the View, there you can select the fields from the new table(s).


Hope this help.

------------------------------
Jesper Bjerre
------------------------------

Hi Buddhi,
It's not currently supported, but on the list of things to be addressed.
// Henk

------------------------------
HENK CAZEMIER
------------------------------

Original Message:
Sent: Tue April 14, 2020 04:42 AM
From: Jesper Bjerre
Subject: Data Module Table Update

Hi Buddhi

I have the same problem using 11.1.5

One way is to create a new view on top of the current view and also select the new table(s) and then change the Identifier on both views, so the new view gets the old views Identifier, this way the relations use the new view.

Another workaround I use is creating a new calculation(s) in the View, there you can select the fields from the new table(s).


Hope this help.

------------------------------
Jesper Bjerre
------------------------------

Hi @Buddhi Gupta,

As Henk mentioned, this is not in the product now but is a well known enhancement request and we definitely recognize the need for it. Glad to say that this is on the roadmap to be addressed.

In the meantime, I attached a document written by @DENNY NAREZNY with a workaround which highlights how you can achieve this today.

Best Regards,​​

------------------------------
MOHAMMED OMAR KHAN
Offering Manager
IBM Cognos Analytics
------------------------------

Original Message:
Sent: Fri April 17, 2020 12:36 AM
From: HENK CAZEMIER
Subject: Data Module Table Update

Hi Buddhi,
It's not currently supported, but on the list of things to be addressed.
// Henk

------------------------------
HENK CAZEMIER
------------------------------


Original Message:
Sent: Tue April 14, 2020 04:42 AM
From: Jesper Bjerre
Subject: Data Module Table Update

Hi Buddhi

I have the same problem using 11.1.5

One way is to create a new view on top of the current view and also select the new table(s) and then change the Identifier on both views, so the new view gets the old views Identifier, this way the relations use the new view.

Another workaround I use is creating a new calculation(s) in the View, there you can select the fields from the new table(s).


Hope this help.

------------------------------
Jesper Bjerre