When creating a custom table insert, when you map some tables to the parameters. By default the Raw table is mapped.
Normally I always use the Valid table. Please map the Valid table by default instead of the Raw table.
Or maybe create a project setting which allows you to set the default mapping (Valid of Raw).
And when "suffix valid tables" is selected as a project option, name it <table name>_V as well.
That way you can easily test in SSMS or other SQL scripting tools and just paste it onto TX.
Hi CalmCo support,
It is possible to see the actual SQL query. When you click the 'Show translation' option. See below.
This is the code you can copy to SSMS.
I think you have to adhere to the way TimeXtender works behind the scenes.
So when dropping a table on the views I would create two parameters: one for raw and for valid that follow the table names as they are present in the stage or dwh database, taking into account the prefix and suffix settings
I.e. if you have set suffix valid table to yes you get two parameters:
[tablename_R] for raw and [tablename_V] for the valid table. I would also reference them that way in the Object Name/Value column.
For custom scripting I would do the same. If you drag the table into the script create _R and _V parameters and let the user delete the one he doesn't need.
When right clicking on a table don't offer the option "Add Parameter" but offer three options: Add as Raw table, Add as Valid table, add both.
That way you clear up all confusion.
Thanks for your product feedback.
We have passed your input to our R&D department for further evaluation.
The roadmap of our product is focused on a split in ODX, MSW, Semantic Layer and Customer Portal.
With that split we will see new features and functions appear that might exceed your expectations or make the request obsolete.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
