0
Q:

What are the examples of BI Initiatives (Focus Areas)? 

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 322
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 311
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 347
Q:

What is BAS? What is its function ?

Answer

The Business Application Support (BAS) functional area at SLAC provides administrative computing services to the Business Services Division and Human Resources Department. We are responsible for software development and maintenance of the PeopleSoft applications and consultation to customers with their computer-related tasks.


It's called Broadcast Agent Server. Its function is torun the jobs or reports scheduled and can be monitored using Broadcast Agent Console.

Report Error

View answer Workspace Report Error Discuss

0 341
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 306