Answer / ravi

Universe level Filters,By giving object lefvel condition in
univerese .Report level filters ,,Block level
filteres.etc...

Answer / gowthami

1. Universe Level restriction
a. Universe level filter
i. Object level filter
ii. Pre-defined filter
b. Join between tables can also restrict the data
c. Creation of parameter in universe also restrict the data

2. Report Level Restriction
a. Query level filter
b. Drill filter/Report level filter
c. Block filter
d. Input Control

Answer / mahesh225

There are many ways to restrict the data in Bo.

Universe side

1)Universe join
2)Object where class
3)Universe prompts
4)you can also ristrict the data by creating derived tables with certain condtions

Report side

1)Query Filter
2)Report Filter
3)Quick(show/hide)Report Filter
4)Creating variables with certain conditions like

=If([Country]="USA") Then 1 else 0

select 1 to display only USA data.

www.futuresoftworld.com

Thanks

Answer / meera nair

In BO,one way of restricting data is by using join.A join
is basically a condition that restricts the result set of a
query.

Answer / darthy

2ways to restrict the data

Hi friends How to design Xcelsius dashboard trough "SAP Netweaver connection" please explain steps for SAP Net weaver connection.

1 Answers  

HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?

1 Answers  

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ? normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2 Answers   iFlex,

Can master data change???if yes then how it'll change.....please explain with example...... thanx

1 Answers  

i want to take a report 10 records per page. How to take it? is there any paging option in BO?

5 Answers   Cap Gemini, IBM,

How will solve a loop caused by lookup table without using alias?

1 Answers   L&T,

Hi , iam beginer in the Boxi . I am getting errors when i applying the @promtps and functions. I want alredy created universe and i absorve the things how those were applied . is it possible to get it throug internet? if it is possible could u plz help me? anandh1110@gmail.com

2 Answers  

How to combine(union) TWO Stored procedures data in a report. It means report has two data providers and one report tab.

1 Answers   IBM,

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

0 Answers  

Can we use unconnected lookup as dynamic lookup?

1 Answers   TCL,

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

0 Answers   PWC,

Can we have multiple domains?

3 Answers