Search results for query: *

Hi, If I use the count Previous year, will the transformation roll up the number for the whole year? I'm not too sure if I can use the transformation, cux it's not exactly year on year. Like if you want to compare the number for 2003 and 2004, 2004 has only 4 months data while 2003 got 12...

I'm kinda new to MSTR, for the OLAP service, are you referring to those OLAP functions, like applysimple, applycomparison? Thanks again for your help.

I need to do a % change metric from the same metric but different time period. Currently, I've a attribute - country and Year, a metric - count. E.g. Year 2003 2004 Country Metric Count Count U.S. 100 20 German 140 50 Japan 110 25...

I need to create a linear regression line with upper and lower bound on a graph. The option that I see from MSTR is check the "show trendlines" check box, but it's only a single line. That's why I need to create a metric, 1 for the upper bound and 1 for the lower bound. The...

using Sum(PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want...

Hi, Z3 tried applysimple("(#0*#1)", sum(paidamt), [saleyear]@ID) too, same error message returned. I also tried something like applysimple("(#0*#1)", sum(paidamt), int([saleyear])), doesn't work either, the only expression that is valid is the First function...

Hi, Thanks for replying. That's just an example, doesn't have an meaningful values. I tried using applysimple("(#0*#1)", sum(paidamt), [saleyear]), but it will give me error message saying "Object (of type: Attribute) not allowed in this place."

Is that possible to create a metric to do calculation from a Attribute and a metric in MSTR? E.g. Attribute 1 is SaleYear(datatype = integer) and Metric 1 is sum(PaidAmt) Need to create something like (SaleYear * sum(PaidAmt)), no aggregate function needed for SaleYear. Thanks!

Thanks to all for helping me again. I used "qualify on an attribute" and change the prompt style to "Text File and Shopping Cart". That's what I need for the report. But I'll try Nate's suggestion and play around with the setting options. Thanks again.

I think I know what is element prompt now, I tried but doesn't work for my situation. I can't use an element prompt cux there'll be too many elements to load, it took about 10 mins. And I can't use a filter to eliminate some elements. Thats's why I need another alternatives.

Thanks for replying me. I'm fairly new for using MicroStrategy to create reports. Can you give me more explanation for creating an element prompt? Thanks again.

Text Prompt under Value Prompt can only allows a single value input from users. Is there any other options to create a prompt that end-users can input more than one values?