Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

metric definition

Status
Not open for further replies.
Lesio

Lesio

MIS
Jan 7, 2003
48
US
Anybody could help how to create the following metric in 7.1.x accessing Teradata ?

metric = CASE WHEN Month in (Jul, Jan, Sep, May) THEN 1 ELSE 0 END

Month is a accessed from a Date attribute.

Thanks,
Lesio
 
Sort by date Sort by votes
Does the Teradata language have the "CASE" statement like Oracle or MS-SLQ? If so, then you can use ApplySimple function in Microstrategy.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ABSU
  • Locked
  • Question
Last 7, 30, 90 Days metrics creation (Microstrategy )
Replies
0
Views
231
ABSU
ABSU
kadicon
  • Locked
  • Question
conditional metric on drilling
Replies
0
Views
129
kadicon
kadicon
szeiss
  • Locked
  • Question
Passing Prompt Answer to Metric
Replies
0
Views
167
szeiss
szeiss
MSlearner
  • Locked
  • Question
metric with case function doesn't work as a report filter
Replies
0
Views
92
MSlearner
MSlearner
cheesyman5k
  • Locked
  • Question
Dimesional Metric Issue (not grouping in SQL)
Replies
1
Views
89
reisw
reisw

Part and Inventory Search

Sponsor

Back
Top