-
Join with a constant
Hello, In a direct query model, is it possible to have a join with a constant value ? For e.g. can I have the join as tableA.date = tableB.date tableA.type = 'Type1' another join tableA.date = tableC.…
- Answered
-
Date Data Points
Hello, I have a requirement to display various measures for Current Year Prior Year End Prior Qtr End Measures would be for e.g. Balance YTD Growth % (Current Month - Prior Year End Bal)/Prior Year…
-
Model management tools
Hello, Are there any inherent model management tools available in Pyramid ? In essence, if I have models in UAT and Production and I want to get Production updated from UAT as part of a promotion but…
- Answered
-
IN operator in Pyramid Formulate (Custom Column)
Hello, What's the best way to setup an IN operator in Pyramid formulate ? For e,g. I want to be able to do something like if (colvalue in ("10","11"....…
- Answered
-
Schedule Model Refreshes for a window of time
Hello, Is it possible to schedule a model refresh every M - F between 8 AM and 6 PM every 15 mins ? I know I can setup multiple schedules one every Mon every 15 mins,…
- Answered
-
Download Pyramid Discovers on a schedule to an OS folder
Hello, Just wanted to check if there is a way we can have the discovers run automatically and land an excel file into an OS folder (Windows or a Samba file share) Thanks Mad
- Answered
Latest Posts