Knowledge Base Article

OneStream 9.0 Stage Schema Changes

Version 9 introduces a streamlined Stage implementation, which might require some changes in how stage-related queries and rules are implemented.

Introduction As part of our ongoing commitment to improving functionality and performance, the 9.0 OneStream release includes significant changes to the database schema related to Stage operations....
Updated 8 months ago
Version 2.0
Chris-B's avatar
Chris-B
New Contributor III
10 days ago

Hi,

Adding the COLLATE clause results in error: 

Database query error. The specified SQL statement is not safe.

Chris

Chris-B's avatar
Chris-B
New Contributor III
10 days ago

As adding the COLLATE clause results in an error when using the SQL method in a data adapter, you have to change the method to a business rule and run the SQL script from there. Not sure why OneStream decided it is not safe to run specific SQL functions directly from a data adapter but deems it to be safe to do so via a business rule šŸ¤”

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    10 days ago

    Is there a particular reason for not using the views instead? "Unless there is a clear and significant performance difference, queries should be performed on views."