I created a Drill-Through process that returns records from an MS-SQL database. In the WHERE clause, I parameterized the ENTITY, PERIOD and ACCOUNT dimensions then used ELLEV and ELISANC in the drill rules against the ACCOUNT dimension to prevent users from executing the query against C-level and Comp and Ben accounts. As long as the user goes down to the zero-level for both Account and Entity dimensions then the query returns results. I may need to write ELLEV level drill rules for ENTITY, but may tackle that later on.
I am going to add the following code (below) to the top of Prolog to ensure that the connection to the database is available. However, is it possible to display "The database containing the GL Transactions is currently unavailable. Please try again later." within PAW and PAfE should the 'ConnectionTest' fail?
Code: Select all
ExecuteProcess( 'ConnectionTest');
NumericGlobalVariable( 'ProcessReturnCode');
If( ProcessReturnCode <> ProcessExitNormal());
ProcessQuit;
EndIf;
Thank you in advance,
Michael