Input metric formula creates error in micro strategy

Asked By Michael M Terry 0 points N/A Posted on - 08/14/2014

Hello,

DBO only functions may not be used in a derived metric – this is the error that appears when I’m working at home. At the college everything is working just fine and I followed the same steps at home and it seems like it doesn’t want to work. Can anyone tell me please what I did wrong ?

Thanks !

MicroStrategy Desktop

DBOnly functions may not be used in a derived metric.

• Status: Open
• Question Views: 848
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By Paul Martine 0 points N/A #178362

Input metric formula creates error in micro strategy

Microstrategy Apply function (DB Functions) gives entrance to functions or syntactic constructs that are not typical in MicroStrategy.

 It is provided by a variety of Relational Database Management System (RDBMS) platforms like;

·         Concat,

·         Ltrim,

·         Case statements etc.,

It does not support to use Apply function (DB Functions) at the time of creating derived metrics when derived metrics are assessed in-memory. Then, their computation does not need any SQL to be carried out against the database.

Design Derived Metric is as a Standalone metric outside report.

 

 

About Paul Martine

Questions
0

Answers
99

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 08/14/2014
• Question Category: Misc Software