I want to get sales data for the last (suppose 10) dates
dynamically
using value prompt how can i do it and drag it onto report
editor.

Answers were Sorted based on User's Feedback



I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can i..

Answer / pritika

create a required value prompt on date attribute ,and
accordingly drag it in your report and save it.

Is This Answer Correct ?    6 Yes 0 No

I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can i..

Answer / amit

make a applysimple filter that calculates the start date as
the sysdate - the n days (here 10) and end date as sysdate.

this will give you the data related to sales of last n
dates.

Is This Answer Correct ?    5 Yes 1 No

I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can i..

Answer / divya

Value prompt is used for User Selected Values which can be
qualified on datatype based on date.

Is This Answer Correct ?    2 Yes 0 No

I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can i..

Answer / vivek jain

You can do it without using value prompt with below steps.
Create a filter on day attribute qualified on ID operator >
and set value to resolve dynamically today – last 10 days.

Is This Answer Correct ?    2 Yes 0 No

I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can i..

Answer / sunil.hit

actually its not that easy as it seems.
Transformation is required for accurate data. which is at high prioritization.

1)create a transformation table ...year to day type.
2)add this table to warehouse catalog
3)create a new attribute with many to many transformation mapping
4)update your schema obj
5)now create new matric...use (sum(sales)-last_10_days)
exp
6) place this particular metric and apply a dynamic prompt


it should work perfectly fine for every kinda data...for months also you can do in same way. but creating transformation is must.

Is This Answer Correct ?    1 Yes 0 No

I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can i..

Answer / pritika

in this we can just create a report filter and call simple
prompt in this filter, in this filter use the between
operator which can fetched the data of two dynamically give
date by user .

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Micro Strategy Interview Questions

How will you monitor the errors received while running i-server and report?

0 Answers  


Your application mode has crashed. A.) How would you run your i-server? B.) How would you get the instance back?

0 Answers  


You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?

0 Answers  


Does microstrategy web support clustering via cisco local router or any other third-party clustering software?

0 Answers  


Does microstrategy intelligence server run on windows®, unix®, or linux®?

0 Answers  






I want to learn Microstrategy Tool...Can you help me to find best coaching center for Microstategy..please send details to maheswari.umaece@gmail.com Thanks and Regards, Uma

4 Answers  


What is the Minimum Qualification to learn the micro strategy course.??

1 Answers   Minacs,


what is microstrategy narrowcast server?

0 Answers  


What are prompted filters?

0 Answers  


what are the nulls on microstrategy report and how to mask them.

1 Answers   iGate, TCS,


What do you mean by consolidations?

0 Answers  


You have got the requirement from a client. Explain the technical approach you will take now.

0 Answers  


Categories