Article Lydia Huang · Mar 14, 2016 4m read Example of using the MDX subquery flag in the DeepSee Shell The DeepSee Shell Best Practices Series - Example of using the MDX subquery flag in the DeepSee Shell We have different flags for DeepSee advisors to look into the execution details and the methods DeepSee is using to do calculations. flag [flagname] [on|off] – Turn a diagnostic on or off. flag cmbr on|off – Show current member processing. flag compound on|off – Show rewrite of compound queries. #InterSystems IRIS BI (DeepSee) #MDX 2 0 0 465
Article Lydia Huang · Mar 14, 2016 6m read Get your MDX query plan, MDX Query Trace and more from the DeepSee Shell The DeepSee Shell Best Practices Series - Get your MDX query plan, MDX Query Trace and more from the DeepSee Shell To process a query, DeepSee performs the following steps: 1. Preparation, which occurs in process (that is, this step is not launched as a background process). In this phase: #InterSystems IRIS BI (DeepSee) #MDX 2 0 0 851
Article Lydia Huang · Mar 14, 2016 3m read Execute an MDX query in the DeepSee Shell with/without results cache The DeepSee Shell best Practices Series - Execute an MDX query in the DeepSee Shell with/without results cache This cache is different from cache reset. Cache reset clears everything in the namespace but “cache off” only clears the cache in ^DeepSee.Cache.Results and ^DeepSee.Cache.Axis global node for the corresponding cube. The difference is quite smaller in the case as below, but in some cases it can be a big difference. #InterSystems IRIS BI (DeepSee) #MDX 2 0 0 437
Article Lydia Huang · Mar 14, 2016 3m read Reset your DeepSee cache in the DeepSee Shell The DeepSee Shell Best Practices Series - Reset your DeepSee cache in the DeepSee Shell This method is provided as a convenience for developers for use on development or test systems. You should not use this method on production systems as it will have immediate effect on the performance of end user operations. #InterSystems IRIS BI (DeepSee) #MDX 2 0 0 428
Article Lydia Huang · Mar 14, 2016 4m read Get your MDX query performance stats from the DeepSee Shell The DeepSee Shell Best Practices Series - Get your MDX query performance stats from the DeepSee Shell DeepSee Shell can show MDX query stats and result set stats. #InterSystems IRIS BI (DeepSee) #MDX 2 0 0 520
Article Lydia Huang · Mar 11, 2016 4m read Run MDX queries in the DeepSee Shell The DeepSee Shell Best Practices Series - Run MDX queries in the DeepSee Shell Introduction to DeepSee Shell There is a basic introduction video about DeepSee shell on InterSystems video portal. #InterSystems IRIS BI (DeepSee) #MDX 2 2 0 679
All posts
All posts
All posts