what is view filter

Answer Posted / guest

view filter is nothing but simple filtering condition but used only when,
a report is executed and some data is being returned. In other words you are just applying filter over the view of data. This is one of the very useful olap property.

EX:
you are developing a report with country and sales

data are some what...

india 1000m
US 10000m
china 8000m

now you just want to view only one country and sale of it.
so, just apply a filter over that executed report.

then it just return like
India 1000m

keep in mind that it will have no effect over the executed SQL in earlier report.
IT will also increase the process and Interaction with client will good.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rank metrics in microstrategy?

755


What are the different types of metrics available in microstrategy?

744


What leads to a cross-join or how does a cross-join occur?

742


what do you mean by security filter?

743


What is a security filter in microstrategy?

745


Explain true primary keys?

735


Can you create an event based schedule in microstrategy? How?

804


Does microstrategy intelligence server support scheduling?

801


Explain rw document?

844


Explain system call error?

786


Explain absolute filter?

744


Explain static reports?

743


What do you mean by dimensional modeling and relational modeling?

658


what is the difference between microstrategy and cognos?

723


how can you direct the sql generated to use a specifc table?

716