MCCC Knowledge Base

CROA - Creating the query

2015

In Web Intelligence, you are going to create a query using the following objects in the universe:

 

  1. Open the Web Intelligence HTML interface, and click the New icon.

 

 

The Create a document dialog box appears.

 2. To select your universe data source, click Universe, then OK.

 The Universe dialog box appears.

3. Select the desired universe and then click OK.

The Query Panel appears.

 

4. In the Universe Outline pane, expand the Time period folder and select Quarter.

 5. Click the right angle bracket (>) button next to the Result Objects pane.

 

Tip

(You can also drag and drop the Quarter dimension into the Result Objects pane.)

 

 

 

 

The Quarter object appears in the Result Objects pane.

 

6. Expand the Store folder and select State.

 

7. Click the > button.

 

  The State object appears in the Result Objects pane.

 8. Expand the Product folder to select Lines, and then click the > button.

  

 

The Lines object appears in the Result Objects pane.

 

9. Expand the Measures folder to select Sales revenue and then press CTRL and click Quantity sold, Margin, and

Discount.

 

 

  

10. Click the > button.

 

 

 

The Sales revenue, Quantity sold, Margin, and Discount objects appear in the Result Objects pane.

 

11. Click Run Query.

 

When the query is run for the first time, Web Intelligence automatically creates a report and document and opens them in Design mode. All of the objects that you selected appear in the Available Objects list and in a table that you’re going to configure.

 

 

 

  

12. Click the Save icon.

 

 

 The Save As dialog box appears.

 13. In the File Name text box, enter Sales report and click Save.

 

 

0 (0)
Article Rating (No Votes)
Rate this article
Attached Files
There are no attachments for this article.
Comments
There are no comments for this article. Be the first to post a comment.
Name
Email
Related Articles RSS Feed
CROA BI launch Pad 4.x Tutorials
Viewed 2817 times since Thu, Jul 9, 2015
CROA - Getting Started with SAP - What is SAP BusinessObjects Web Intelligence
Viewed 3296 times since Wed, Jul 8, 2015
Ending a Scheduled CROA Report
Viewed 2631 times since Tue, Feb 2, 2016
Setting CROA recommended preferences
Viewed 1981 times since Thu, Jun 23, 2016
How can I avoid encountering the "Ping" error when I try to refresh reports in InfoView?
Viewed 4010 times since Tue, Mar 24, 2015
CROA - Working with content objects
Viewed 2654 times since Thu, Jul 9, 2015
Scheduling CROA reports
Viewed 2601 times since Wed, Oct 22, 2014
CROA - Viewing objects
Viewed 2442 times since Thu, Jul 9, 2015
CROA Video tutorials
Viewed 2581 times since Thu, Jul 9, 2015
CROA - How to customize a table in the report
Viewed 2568 times since Wed, Jul 8, 2015

Need Help?