pls ans what are the filters we have in framework manager?
filters in report studio?
- 3 Answers
- 13204 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / krishna kumari
We have 2 types of filters
stand-alone filters and embedded filters
Use a stand-alone filter when you want to reuse the expression.
Use an embedded filter when you want to use a filter with
only one dimension or query subject.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / modipalli
we have 2 types of filters in Frame work manager and Report
studio.
In frameworm manager :
1. Stand alone filter
2. Embeded filter.
In report studio :
1. Detailed filter
2. Summary filter.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / swamy
Hi,
In framework Manager we have 2 types filters,
1.Stand alone filters:-
A.Use a stand-alone filter when you want to reuse the expression.
B.You can add a stand-alone filter to one or more dimensions or query subjects to limit the data that the query retrieves when the filtered dimension or query subject is used in a report.
2.Embedded Filter:-
A.Use an embedded filter when you want to use a filter with only one dimension or query subject.
B.You can create an embedded filter when modifying a dimension, relational data source query subject, or model query subject.
In report studio We have 3 Types Filters,
1.Tabular Filters:- In this two types,
A.Detailed Filters:-Filter is applied before aggregation as aggregation (detail)records are filtred
B.Summary Filters:-Filter applied after aggregation than aggregated (summary) records are filtered.
2.Grouped Filters:-
Filter which is applied to the group as group records are filters, known as Group Filters.
3.Slicer:-
A.Specifies the expression that defines the slicer member set. Slicer Applies to Slicer Member Set
B.A set of expression that returns members from a single hierarchy of a single dimension.
| Is This Answer Correct ? | 1 Yes | 0 No |
Sales person are there in one company How to do Bursting on this particular requirement?
How do you call a store procedure within a transformation?
What are cognos connection initial page components?
how u create cubes in ur project
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha
what are diff b/w cognos and business objects
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What is the use of powerhouse?
What are different events in Report studio?
How can you schedule a report based on different time zone ?(ex: local time should be same as 10 am . Japan should get the report at 10 am. USA should get the report at 10 am).Is that possible?
What is cognos connection?
Teradata 
