Spotfire Ideas Portal
Is it possible to create "Undefined" data type document property in DXP as it is available in Information designer on "Parameters" section.
Use:
1.If Spotfire can replace the parameters in information link as is for example with no string formatting like enclosed quotes(") it will be helpful to re-point schema name and tables names for dynamically changing the data source based on user selections at run time.
2.Will extend the capabilities of SQL overrides in Information services.
Thanks,
Prapul Garikipati
I think the idea to allow String document properties and expressions to be assigned to Undefined parameters a better approach. With this we can implement complex filtering to be passed to the sql when required by business use case. Especially when we are querying huge tables.
"Customers are wanting to be able to use data from table to change the table name used in another on-demand table." => I don't really get why you would want to change table names. But sounds like something you shouldn't really do and more of hack of badly led user process. In any case you either use SYNONYMS or VIEWs to hide the actual table name from Info Designer and change it at will without affecting your information links. You could use Procs to completely hide the data table structures and return generic data types.
It might be easier to allow String document properties and expressions to be assigned to Undefined parameters rather than implementing a new data type. In all the use cases I've seen we would pass strings to the Information Link. We're able to pass parameters to these sort of Information Links using Configuration Blocks, but we can't pass them for on-demand tables.
Customers are wanting to be able to use data from table to change the table name used in another on-demand table.
The information Link almost allows you to do this, but then will not allow this Undefined parameter to be populated from a table string value.
What exactly are you trying to achieve?