0
Q:

What is BAS? What is its function ? 

Answer:
Q:

What is hierarchy relationship in a dimension. whether it is: 1) 1:1 2) 1:m 3) m:m

Answer

1:m

Report Error

View answer Workspace Report Error Discuss

2 323
Q:

Why we can't create an aggregate on an ODS Object?

Answer

1. Operational Data Store has very low data latency. Data moved to ODS mostly on event based rather than time based ETL to Data Warehouse/Data Mart. 


2. ODS is more closer to OLTP system. We don't normally prefer to store aggregated data in OLTP. So it is with ODS. 


3. Unlike data warehouse where data is HISTORICAL, ODS is near real time(NRT). So data aggregation is less important is ODS as data keeps changing.

Report Error

View answer Workspace Report Error Discuss

2 315
Q:

How do we Tune the BO Reports for Performance Improvement?

Answer

We can tune the report by using index awarness in universe

Report Error

View answer Workspace Report Error Discuss

2 349
Q:

Why an infocube has maximum of 16 dimensions?

Answer

Because any Database will supports only 16 foreign keys in a database table. 


It depends upon the Database limits provided to define the Foreign key constraint, e.g. in Sql Server 2005, the recommended max limit for foreign keys is 253, but you can define more.

Report Error

View answer Workspace Report Error Discuss

0 308
Q:

How do we enhance the functionality of the reports in BO?

Answer

You can format the BO Reports by using various features available. You can turn the table reports into a 2-Dimensional or 3-Dimensional charts. You can apply an Alert to show some data in a different format , based on some business rule. You can also create some prompts, which will asks user to give some input values before seeing the reports, this way they will see only filtered data. There are many similar exciting options available to enhance the reports.

Report Error

View answer Workspace Report Error Discuss

0 274