Re: Create calculated dimension in load script from an associated table in data manager?
Can you share expression, may be it can be improved by some means. You may want to know below rules when it requires manual intervention to data manager generated script -
You can add script sections and develop code that enhances and interacts with the data model created in Data manager, but there are some areas where you need to be careful. The script code you write can interfere with the Data manager data model, and create problems in some cases, for example:
Renaming or dropping tables added with Data manager in the script.
Dropping fields from tables added with Data manager.
Concatenation between tables added with Data manager and tables loaded in the script.
Using the Qualify statement with fields in tables added with Data manager.
Loading tables added with Data manager using Resident in the script.
Adding script code after the generated code section. The resulting changes in the data model are not reflected in Data manager.