Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. In general, a user specifies a list of conditions and corresponding return values. Case This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. If all conditions are false, a default value is returned. Case can be used for categorizing data based on multiple conditions. This is a single-value function. Syntax Case ( Condition1 , ReturnValue1 , Condition2 , ReturnValue2 ,..., DefaultValue ) Example Case(([Total Revenue] < 300000), 0, ([Total Revenue] < 600000), 1, 2) sum(Case (Day@DESC in (āSatā,āSunā), Sales, 0) {~+} Sum(Case(Category@DESC In("Books","Electronics"),Revenue,0)){~+} CaseV (case vector) CaseV evaluates a single metric and returns different values according to the results. It can be used to perfo...
Microstrategy Business Intelligence knowledge sharing platform
Such a nice blog with the attractive reference links which give the basic ideas on the topic.
ReplyDeleteData Science vs Business Analytics
Business Data Analytics
Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing
ReplyDeleteMicro Strategy Certification
Micro Strategy Training Online
nice information thanks for sharing..!
ReplyDeletemicro strategy certification training
Hi Thanks For Sharing We are the best Digital Marketing Agency at Lebynd
ReplyDelete