what is view filter
- 9 Answers
- 10287 Views
- IBM, Marlabs, Ness Technologies, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
It restricts the data being displayed on the report with out
re executing against data base.This improves response time
and decreases database load.
| Is This Answer Correct ? | 12 Yes | 2 No |
Answer / guest
Apply specfic filter condition then after we can get the
report data set. it is olap.view filter main use viewing
purpose for custmoers.
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / praveen kumar sivvam
View filter dynamically restrict the data being displayed
in the report.
It doesn't effect to the SQL
EX: I have report with the year and revenue objects. I want
a revenue for the year 2008 only then it wl be useful.
| Is This Answer Correct ? | 2 Yes | 0 No |
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 |
Answer / sivaprasada rao
view filter is one of the filter in microstrategy we r used view filter after exicution of the report ...the purpose of this filter is to restrict the unwanted data from exicuted report the main advantage of this filter is it doesnot go to warehouse ...exiction time is loww but we cant see it in sql view..............
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / praveen
View filter is an olap services. When we apply this filter
for an executed resultant data of a report set.
it will restrict the amount of data and reexecute the report.
It will not execute against the dataware house.
so there is no change in the sql.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / balaji
we can apply filter condition on fly after running the
report dynamically called view filters. View filters are
local to the report. We can save view filters with report
defination. View filters are not reusable components.
| Is This Answer Correct ? | 0 Yes | 0 No |
view filter is a filter condition we apply on the objects present in report object section in a report .It is applied after the execution of report.
It does not impact sql as it is an OLAP service which gets calculated at analytical engine.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is embedded metric?
What are report filters and view filters?
what do you mean by passthrough functions?
Can a record be inserted and updated in database using microstartegy?
how can we direct the sql generated to use a specifc table?
What subtotaling features does microstrategy desktop contain?
Define different types of attributes in microstrategy desktop?
Your colleague installed microstrategy on solaris or unix without root access. Will he be able to start/ restart this server?
What do you mean by consolidations?
While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?
what are the different types of tests done on a microstrategy report?
Can microstrategy desktop access operational data systems?
Teradata 
