Improve Performance of Data Source Flow Report

Unknown

Improve Performance of Data Source Flow Report

Unknown

Hi,
I want to get my performance of speeding up reporting with something equivalent to a VIEW option like in MS SQL. I attempted to use a data structure with the different fields for the tables but this didnt seem to work as I hoped. Im also using a few MS SQL tables as lookups. How can I get the performance improved?

Unknown

Hi GeeTrends,

One way to improve performance would be to create a view in the database and as an object to call the flow sourced report. To add a view in the local database, write a query to create the view CREATE VIEW myView AS SELECT COLUMN FROM TABLE from either a DBMS database or the query editor. After that dbo.myView will be available from the list of views in System > Integrations > Databases > LOCAL CONNECTION > Add View and Decisions will generate a step for this view. A Table can be identified for user-defined types by right-clicking the type definition, selecting Edit Defined Data Structure, and locating the Table Name property on the right-hand side.