SAS BI Interview Questions and Answers

1. What is SAS Business Intelligence?

SAS business intelligence has analytical capabilities like statistics, reporting, data mining, predictions, forecasting, and optimization. They help in getting data in the format desired. It helps in improving the quality of data.

2. What is Business Intelligence?

As the name suggests it’s the Intelligence one gains from the business; about the business. Typically it is achieved by various Data warehousing, Data mining, and reporting tools and techniques.

3. Where to Use SAS Business Intelligence?

SAS BI provides information about an enterprise when needed. It provides this information in a customized format. SAS BI integrates data across the enterprise and delivers self-service reporting and analysis. This consumes less time for responding to requests and for business uses to view the information. An integrated, flexible, and robust presentation layer for SAS Analytics with full breadth is also offered by SAS BI. All these are integrated within the context of business for better and faster decision-making.

4. What are the software’s and applications that are used most frequently used by SAS bi applications developers?

  • SAS Appdev Studio
  • SAS A/F
  • SAS/Internet

5. What are the applications primarily used by business analyst?

  • SAS bi dashboard
  • SAS Enterprise Guide
  • SAS Information Map Studio
  • SAS OLAP Cube Studio
  • SAS Stored Process
  • SAS Visual BI

6. What is METADATA?

Metadata is often referred to as “data about data”; but I would like to say it as it is nothing but additional information of your data.

Usually many applications which deal with the DATA need some basic information about it from their perspective; for example, a database system where you are going to save the data needs to know how the user wants the data to be saved? So when you fire a create table command on the database is nothing but you give that information to the database system. In more specific terms, you define the table structure which is gets recognized as tables Metadata.

7. How many types of prompt are there?

The four types of prompts are:

  1. Dynamic prompts
  2. Cascading prompts
  3. Relative date/Time prompts
  4. Range prompts

8. What is BAS? What is the function?

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 the software development and maintenance of PeopleSoft. Applications and consultation to customers with their computer-related tasks.

9. What is the purpose of reporting?

That is more self-explanatory than previous questions. The ability to view or create reports by users is the short answer but usually, reporting tools like SSRS are much more powerful and they allow to set up subscriptions, provider reports in different usable for users formats, secure reports, and so on.

10. How do we Tune the BO Reports for Performance Improvement?

We can tune the report by using index awareness in the universe

11. What are several options for creating reports in Web Report Studio?

There are three options

  • Report wizard which consist of five steps
  • Templates that contain report layout information
  • Edit mode, which provide full control over all aspects of report creation

12. What are SAS BI dashboard components?

Data model, dashboard, indicator, ranges

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

You can format the BO Reports by using various features available. You can turn the table reports into 2-Dimensional or 3-Dimensional charts. You can apply an Alert to show some data in a different format, based on some business rules. You can also create some prompts, which will ask users 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.

14. What is the mean of BOMain.Key in business intelligence?

Balmain. The key file contains all relevant information about the repository. It contains the address of the repository security domain.


15. What are the component of range

code interval, interval, label, color

16. What is broad cast agent in business intelligence?

A broadcast agent allows the automation of emails to be distributed. It allows reports to be sent to different business objects. It also users to choose the report format and send via SMS, fax, pagers, etc. broadcast agents allows the flexibility to the users to receive reports periodically or not. They help to manage and schedule the documents.

17. Why we cannot create an aggregate on an ODS Object?

  • 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.
  • ODS is closer to OLTP system. We don’t normally prefer to store aggregated data in OLTP. So it is with ODS.
  • 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.

18. What is slicing in business objects?

Slicing and dicing of business objects are used for a detailed analysis of the data. It allows changing the position of data by interchanging rows and columns.

19. How to connect GDE to Co Operating system in Abinitio?

We can connect Ab Initio GDE with Co>operating system using Run->Settings. In there u can specify the host IP address and the connection type . Refer to Ab Initio help for further details.

20. What is OLAP, MOLAP, ROLAP, DOLAP, HOLAP? Explain with Examples?

OLAP – On-Line Analytical Processing.

Designates a category of applications and technologies that allow the collection, storage, manipulation, and reproduction of multidimensional data, with the goal of the analysis.

MOLAP – Multidimensional OLAP.

This term designates a cartesian data structure more specifically. In effect, MOLAP contrasts with ROLAP. In the former, joins between tables are already suitable, which enhances performances. In the latter, joins are computed during the request.

Targeted at groups of users because it’s a shared environment. Data is stored in an exclusive server-based format. It performs a more complex analysis of data.

DOLAP – Desktop OLAP.

Small OLAP products for local multidimensional analysis Desktop OLAP. There can be a mini multidimensional database (using Personal Express), or extraction of a datacube (using Business Objects).

Designed for low-end, single, departmental users. Data is stored in cubes on the desktop. It’s like having your own spreadsheet. Since the data is local, end-users don’t have to worry about performance hits against the server.

ROLAP – Relational OLAP.

Designates one or several star schemas stored in relational databases. This technology permits multidimensional analysis with data stored in relational databases. Used for large departments or groups because it supports large amounts of data and users.


Hybridization of OLAP, which can include any of the above.