Business Intelligence Questions

Q:

What is Catalog Manager? How to move reports and dashboards using Catalog Manager?

Answer

Catalog Manager supports command line options.


 


To move reports and dashboards, we need to use some general syntax using catalog manager.


 


e.g:


catalogmanager -online/offline


-cmd {report | replace | export}


{command line options}


In extra, by keeping it online, This will automatically open up the catalog 


manager without having the need to enter the connection details every time.

Report Error

View answer Workspace Report Error Discuss

0 2183
Q:

what is flat aggregation?

Answer

If you create an Aggregate with more than 16 characteristics, then we call that aggregate as FLAT Aggregate. When an aggregate is active then new data is not available for reporting,These aggregates are called Flat Aggregates.

Report Error

View answer Workspace Report Error Discuss

0 1807
Q:

What are the core BI tools that professionals work with? Which ones have you used?

Answer

SSIS, SSAS and SSRS are the most important reporting systems that BI professionals work with. On a detailed level, I have worked with data mining, master data management, data profiling and data cleansing and analysis.

Report Error

View answer Workspace Report Error Discuss

0 1785
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 1782
Q:

What is a BI dashboard?

Answer

Dashboards are real-time business intelligence interfaces. They allow a huge amount of data to be read in a single interface in order to analyse the success or failure of the business or project in question

Report Error

View answer Workspace Report Error Discuss

0 1690
Q:

Which of the following is a function of inventory?

A) to take advantage of quantity discounts B) to decouple various parts of the production process
C) to provide a selection of goods for anticipated customer demand and to separate the firm from fluctuations in that demand D) All the above
 
Answer & Explanation Answer: D) All the above

Explanation:

All the above given statements are functions of Inventory.

 

Inventory or stock is the goods and materials that a business holds for the ultimate goal of resale. Inventory management is a discipline primarily about specifying the shape and placement of stocked goods.


The primary function of inventory is to use marketing and production to increase profitability, to get the maximum amount for the business' investment. There are other functions of inventory, such as balancing supply and demand, improving efficiency, establishing a safety stock and geographical specialization.

Report Error

View Answer Report Error Discuss

Filed Under: Business Intelligence - Technology
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

0 1568
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 1519
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 1479