0
Q:

Why an infocube has maximum of 16 dimensions? 

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 312
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:

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 273