Josh,
You know those situations where you want to drop and recreate something, or create something if it doesn't exist? You can use the object_id function to check if an object exists in the database.
Josh, you learned something cool or figured something difficult out relating to BI/SQL/C#/Programming/Etc. Therefore write it down here for easy recall!!!
Monday, June 16, 2014
Monday, June 9, 2014
SSAS Dynamic Prior Period
Josh,
When using the prior period function and you want the calculation to work on any level of the hierarchy, you'll need to remember the "CurrentMember.Level" syntax:
When using the prior period function and you want the calculation to work on any level of the hierarchy, you'll need to remember the "CurrentMember.Level" syntax:
Subscribe to:
Posts (Atom)