Download - RPD Creation
-
8/2/2019 RPD Creation
1/62
RPD Creation
-
8/2/2019 RPD Creation
2/62
-
8/2/2019 RPD Creation
3/62
-
8/2/2019 RPD Creation
4/62
Click OK and again OK
-
8/2/2019 RPD Creation
5/62
Click OK.
-
8/2/2019 RPD Creation
6/62
-
8/2/2019 RPD Creation
7/62
Select channels, Products, Sales and Times Table and Click Import. Once imported Click close to exit the
wizard
Double-Click Connection Pool
-
8/2/2019 RPD Creation
8/62
Creating Alias for a table
-
8/2/2019 RPD Creation
9/62
Enter the alias table
-
8/2/2019 RPD Creation
10/62
The alias table is displayed below
-
8/2/2019 RPD Creation
11/62
When compared both (channels and CallCenter_Channels). The channels have a Primary Key on the field
CHANNEL_ID but that does not exist in CallCenter_Channels.
When an alias table is created it has only the columns from the physical table and does not contain any
Primary or Foreign which resides in the physical table.
Creating Primary key in alias table (1st-Method)
-
8/2/2019 RPD Creation
12/62
(2nd Method)
-
8/2/2019 RPD Creation
13/62
Click New Button
-
8/2/2019 RPD Creation
14/62
Star Schema creation
-
8/2/2019 RPD Creation
15/62
Creating a foreign key relation between dimension and fact table
Dimension Table CallCenter_Channels
Fact Table CallCenter_Sales
-
8/2/2019 RPD Creation
16/62
-
8/2/2019 RPD Creation
17/62
Objects and Direct Joins to a fact table
-
8/2/2019 RPD Creation
18/62
Business Model and Mapping
-
8/2/2019 RPD Creation
19/62
-
8/2/2019 RPD Creation
20/62
-
8/2/2019 RPD Creation
21/62
-
8/2/2019 RPD Creation
22/62
Drag and Drop Sales Table field(Amount_Sold and Quantity_Sold) on Fact Sales (BMM)
-
8/2/2019 RPD Creation
23/62
Go to Aggregation Tab
-
8/2/2019 RPD Creation
24/62
Default Aggregation rule dropdown contains
None, Sum, Avg, Max, Count, Count distinct, Min, First, Last, Median, StdDev, StdDevPop, Evaluate_Aggr
Choose Sum
-
8/2/2019 RPD Creation
25/62
After applying aggregation rule, the field symbol changes like sigma sign. See Amount_Sold field
-
8/2/2019 RPD Creation
26/62
Repeat the steps for Quantity_Sold field by applying the aggregation rule Sum, the UI displays (Both
the fields having sigma sign)
Any table in the BMM is stand alone table. Atleast connected to one table
-
8/2/2019 RPD Creation
27/62
-
8/2/2019 RPD Creation
28/62
After applying complex join
-
8/2/2019 RPD Creation
29/62
Publish RPD in OracleBI Server
-
8/2/2019 RPD Creation
30/62
[Repository] Change to your RPD Name
Any changes made in the NQSConfig file, BI Server services has to be restarted, to reflect the current
changes.
The Services to be restarted
Oracle BI Server
-
8/2/2019 RPD Creation
31/62
Oracle BI Presentation Server
Oracle BI Java Host (Optional)
-
8/2/2019 RPD Creation
32/62
After login
-
8/2/2019 RPD Creation
33/62
Click Answers Tab
Click on your RPD under Subject Areas
-
8/2/2019 RPD Creation
34/62
Left side displays the Table we have used. Drag and Drop the fields
Click Results tab to view the report
-
8/2/2019 RPD Creation
35/62
Rename Logical Tables
-
8/2/2019 RPD Creation
36/62
Select Rename Wizard and click Execute
In Rename Wizard, Select Business Model and Mapping Section
-
8/2/2019 RPD Creation
37/62
To select the entire Business Model, Click on the Model Name and click the Add Hierarchy Button
-
8/2/2019 RPD Creation
38/62
-
8/2/2019 RPD Creation
39/62
Choose All text lowercase
-
8/2/2019 RPD Creation
40/62
2. Change specified text, Specify in Find and Replace and click Add
-
8/2/2019 RPD Creation
41/62
3. First letter Capital
-
8/2/2019 RPD Creation
42/62
Click Next, Next and Finish
-
8/2/2019 RPD Creation
43/62
-
8/2/2019 RPD Creation
44/62
Login into Presentation, Add any columns. Select the Column Properties- > Style. Specify the Font
family, color, Size , Style and Effect -> ok
-
8/2/2019 RPD Creation
45/62
Move to Results Tab
-
8/2/2019 RPD Creation
46/62
Horizontal Alignment - Center
Horizontal Alignment - Left
-
8/2/2019 RPD Creation
47/62
Image Alignment
Choose Images only
-
8/2/2019 RPD Creation
48/62
Column Properties -> Column Format
To Change the Column heading Check Custom Heading and Enter the Custom Heading Name
Eg I have changed the Prod Name to Product Name
-
8/2/2019 RPD Creation
49/62
Highlighted in Blue
Apply font, size, color and Style to Column Heading.
Click the Edit Format button at the end of Column Heading Text box
-
8/2/2019 RPD Creation
50/62
Use in numeric column
-
8/2/2019 RPD Creation
51/62
Column Properties -> Condition Format ->
Select the column to which the condition to be set
-
8/2/2019 RPD Creation
52/62
Condition Amount sold greater than 3,00,000 ok Edit Format Opens
Set font, color to identify records greater than 3,00,000
-
8/2/2019 RPD Creation
53/62
-
8/2/2019 RPD Creation
54/62
Column Properties -> Edit Formula
+, - ,x, / symbols is used in number columns for adding, subtracting, multiplying and Division
Eg Addition.
-
8/2/2019 RPD Creation
55/62
Bring the cursor to the end of the column name and Click + sign and enter the value to add (e.g., 100).
Click Ok. Go to Results
Functions
Types of Functions
-
8/2/2019 RPD Creation
56/62
Aggregate Function
Count
-
8/2/2019 RPD Creation
57/62
Count Distinct
Results
-
8/2/2019 RPD Creation
58/62
BottonN and TopN
Before adding
After adding BottomN
-
8/2/2019 RPD Creation
59/62
TopN
-
8/2/2019 RPD Creation
60/62
Rank
-
8/2/2019 RPD Creation
61/62
Sum To add all rows
Sum Distinct Distinct values sum
Running Aggregate
-
8/2/2019 RPD Creation
62/62