Create Temporary Table or View for complex agreement template
Seeking advice regarding BI publisher capabilities to create temporary data tables.
I am seeking advice as to whether it is possible to create temporary tables or views within BI publisher for referencing complex queries.
Our use case is that we are needing to conditionally display a complex table within the offer letter for employees hired under award conditions. Currently this data is maintained using an excel worksheet and a number of formulas. This is both due to ease of use and also ease of maintenance where award rates could change at any time.
We would like to create a temporary SQL table within a query that we can then reference with formulas to determine rates that will populate the agreement. The thought process is that by using a temporary table we could update the top of the query without constantly updating the body of the model where the formulas need to retrieve values.