1000 characters left
Don't like using forms? Call us at (630) 692-6700
image
Big Data Consulting
image
Business Intelligence Consulting
image
Partner With Aptude
image
Mobile Development Experts
image
Oracle Fusion Consulting
image
IT Support On-Demand

Aptude's Blog - IT Staffing, Consulting, and Software Development Services

Welcome to Aptude's blogging center! Our blogs are written by experts in each respective field. We hope any information gathered in these articles will be beneficial to you and your company. For more information about how we can assist you with your IT Staffing, IT Consulting, or Software Development needs please give us a call at (630) 692-6700!

Grouping XML Data and Using Aggregation Functions in RTF Template

Grouping XML Data and Using Aggregation Functions in RTF Template
Here I am going to explain how grouping XML Data in RTF Template works. Let’s generate a simple report with SQL data source using SH schema. We can handle grouping and aggregation at the SQL level, but sometimes we have a requirement to use this as an RTF Template.   Step 1: Creating Data Model Here is the SQL using 3 tables to get required columns for the report:         Creation of data model part is done. Save the data mode with Group_DM name and generate XML. Export XML to build RTF Template.   Sample XML that was generated. It is the flat XMLwhich has no aggregations and grouping. <DATA_DS> <G_1>   <CUST_FIRST_NAME>Anne</CUST_FIRST_NAME>   <CUST_LAST_NAME>Koch</CUST_LAST_NAME>   <COUNTRY_REGION>Europe</COUNTRY_REGION>   <COUNTRY_SUBREGION>Western Europe</COUNTRY_SUBREGION>   <COUNTRY_NAME>Spain</COUNTRY_NAME>   <AMOUNT_SOLD>1232.16</AMOUNT_SOLD>   </G_1>   <CUST_FIRST_NAME>Anne</CUST_FIRST_NAME>   <CUST_LAST_NAME>Koch</CUST_LAST_NAME>   <COUNTRY_REGION>Europe</COUNTRY_REGION>   <COUNTRY_SUBREGION>Western Europe</COUNTRY_SUBREGION>   <COUNTRY_NAME>Spain</COUNTRY_NAME>   <AMOUNT_SOLD>1550.99</AMOUNT_SOLD>   </G_1>   </DATA_DS>     Step 2: Build...
Recent comment in this post
Corrie Mieszczak
Thanks for the great post, Sridhar!
Tuesday, 29 January 2013 11:02
Continue reading
19578 Hits
1 Comment

Waterfall Charts in OBIEE 10g and 11g

Waterfall Charts in OBIEE 10g and 11g
  A waterfall chart is a special type of floating-column chart, also known as Flying Bricks Chart or Bridge due to the apparent suspension of the column (brick) in mid-air. A typical waterfall chart shows how an initial value is increased and decreased by a series of intermediate values, leading to a final value. An invisible column keeps the increases and decreases linked to the heights of the previous columns.  Waterfall Charts in OBIEE 10g Note: I am using paint.rpd which comes with the OBIEE installation. 1. Formula: The Answer analysis consists of the following measures: - Forecasted Dollars: Absolute value of Forecasted Dollars. ABS ("Forecast Measures"."Forecasted Dollars") - Intermediate Revenue: Column keeps the increases and decreases linked to the heights of the previous columns. CASE WHEN "Forecast Measures"."Forecasted Dollars"< 0 THEN rsum("Forecast Measures"."Forecasted Dollars")  ELSE rsum("Forecast Measures"."Forecasted Dollars")-"Forecast Measures"."Forecasted Dollars"  END Graph is plotted as stack of ABS (Forecast Measures.Forecasted...
Continue reading
7063 Hits
0 Comments

OBIEE 11G Repository Design: Physical Layer Design Tips

OBIEE 11G Repository Design: Physical Layer Design Tips
OBIEE 11G Repository Design Tips for the Physical Layer The following is a list of tips to use when designing the physical layer:  1) It is recommended that you use table aliases frequently in the Physical layer to eliminate extraneous joins, including the following:a) Eliminate all physical joins that cross dimensions (inter-dimensional circular Joins) by using aliases. b) Eliminate all circular joins (intra-dimensional circular joins) in a logical table source in the Physical Model by creating physical table aliases.For example, say you have a Customer table that can be used to look up ship-to addresses, and using a different join, to look up bill-to addresses. Avoid the circular joins by aliasing the table in the Physical layer so that there is one instance for each purpose, with separate joins.If you do not eliminate circular joins, you might get erroneous report results. In addition, query performance might be negatively impacted.2) You...
Continue reading
4683 Hits
0 Comments

OBIEE 11G Repository Design: BMM Layer Design Tips

OBIEE 11G Repository Design: BMM Layer Design Tips
Design Tips for the OBIEE 11G Repostory Design BMM Layer: 1) Create the business model with one-to-many logical joins between logical dimension tables and the fact tables wherever possible. The business model should ideally resemble a simple star schema in which each fact table is joined directly to its dimensions. 2) Every logical fact table must join to at least one logical dimension table. Note that when the source is a fully denormalized table or flat file, you must map its physical fact columns to one or more logical fact tables, and its physical dimension columns to logical dimension tables. 3) Every logical dimension table should have a dimensional hierarchy associated with it. This rule holds true even if the hierarchy has only one level, such as a scenario dimension {actual, forecast, plan}. 4) When creating level-based measures, make sure that all appropriate fact sources map to the appropriate level in the hierarchy using aggregation content. You set up aggregation...
Continue reading
8223 Hits
0 Comments

OBIEE 11G Repository Design: Presentation Layer Design Tips

OBIEE 11G Repository Design: Presentation Layer Design Tips
Design Tips for the OBIEE 11g Repository Design Presentation LayerIn the presentation layer, you can do the following: 1. Show fewer columns than exist in the Business Model and Mapping layer. For example, you can exclude the key columns because they have no business meaning. 2. Organize columns using a different structure from the table structure in the Business Model and Mapping layer. 3. Display column names that are different from the column names in the Business Model and Mapping layer. 4. Set permissions to grant or deny users access to individual subject areas,tables, and columns. 5. Export logical keys to ODBC-based query and reporting tools. 6. Create multiple subject areas for a single business model. 7. Create a list of aliases (synonyms) for presentation objects that can be used in Logical SQL queries. This feature lets you change presentation column names without breaking existing reports. Design Tips:   1. Because there is no automatic way...
Continue reading
4669 Hits
0 Comments

How to Upgrade from OBIEE 10g to 11g

How to Upgrade from OBIEE 10g to 11g
Need a little guidance with upgrading OBIEE 10g to 11g? The following instructions and screen shots should help. 1) Download the sample data set from the Oracle Technology Network (OTN).   2) Download the 10g Sample Sales data set on a server on which Oracle BI 11g is installed. 3) Unzip the Sample Sales data set. You should see four new files: Sample_Sales_V1.3_Dataset.zip Sample_Sales_V1.3_Readme.txt Sample_Sales_V1.3_Webcat.zip samplesales.rpd 4) Create a subfolder in the samples sales folder and name it as “Sample_Sales_V1.3_Webcat” 5) Now copy the “Sample_Sales_V1.3_Webcat.zip” in to “Sample_Sales_V1.3_Webcat” subfolder and extract all. You will have 10 g sample sales catalog in the folder. 6) Create a new directory named "deliveries" in “SampleSales\Sample_Sales_V1.3_Webcat”. In 10g, the deliveries directory is a special directory used for data such as Dashboard snapshots used by Briefing Books. The directory is called deliveries by default and is located in the OracleBIData\web\catalog directory. In many cases, the 10g directory is...
Continue reading
2533 Hits
0 Comments

OBIEE 11.1.1.6 Installation on Windows-32 Bit - Part 1

OBIEE 11.1.1.6 Installation on Windows-32 Bit - Part 1
Hi,In the OBIEE 11.1.1.6 Certification, I didn't see Windows 32-Bit as supporting Operating system. Still, I gave it a shot to see whether it will work or not.It works!!! Installation of OBIEE invloves 4 steps: 1) Installation of Loopback adopter 2) Installation of database 3) Installation of RCU (Repository Creation Utility) 4) Installation of OBIEE software Installing a Loopback Adapter on Windows XP-32 Bit My System configuration: Ram 8 GB and windows XP Installed on virtual machine   Open the Windows Control Panel. 1.      If you are in Category view switch to Classic view 2.      Double-click Add Hardware to start the Add Hardware wizard 3.      In the Welcome window, click next 4.      Follow the screen shots one by one   In the Properties dialog box, click Use the following IP address and do the following: a. IP Address: Enter a non-routable IP for the loopback adapter. For instance: i....
Continue reading
3342 Hits
0 Comments

New metadata repository features in OBIEE 11g Release

New metadata repository features in OBIEE 11g Release
New features in the 11.1.1.6 OBIEE release include: Ability to Limit and Offset Rows Returned Identify Query Candidates with Oracle BI Summary Advisor Integrate the Administration Tool with a Third-Party Source Control Management System Streamlined MUD Merge Process Automated Repository Patching Process Support for Aggregate Persistence in a Cluster FIRST_PERIOD and LAST_PERIOD Time Series Functions Ability to Print the Physical and Business Model Diagrams   And in 11.1.1.5:  Access to Oracle OLAP Data Sources Access to TimesTen Data Sources Ability to Connect to SAP/BW Data Sources Using a Native Connection New Diagramming Capability Validation Utility to Validate Metadata Objects in a Repository   In 11.1.1.3:  New SampleApp.rpd Demonstration Repository Hierarchy Objects in the Presentation Layer Support for Unbalanced (Ragged) and Skip-Level Hierarchies Support for Parent-Child Hierarchies Creating Subject Areas for Logical Stars and Snowflakes Multicurrency Support Generating and Applying XML Patch Files Enhancements for Multiuser Development and Repository Lifecycle Management Metadata Repository File Encryption Metadata...
Continue reading
2653 Hits
0 Comments

OBIEE 11.1.1.6 is Now Available for Download!

OBIEE 11.1.1.6 is Now Available for Download!
Hi Friends, OBIEE 11.1.1.6 is a new version available to download. http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads  Here's a nice presentation from KPI Partners on the benifits of upgrading from 10g to 11G!!! Oracle Business Intelligence 11g - Why Upgrade? Top Benefits for IT   More to come... Thanks, Venkat
Continue reading
1607 Hits
0 Comments

How to restrict the Values in OBIEE PROMPTS

How to restrict the Values in OBIEE PROMPTS
It is common practice to have year and month prompts on the OBIEE reports. One can set a default year and month by creating a dynamic variable in the RPD (or) using SQL Results. When users want to see the  year-2(2010) or  year-1(2011) one he has to scroll down. When he scrolls down he will see all the rows in the column. For example: The below screenshot shows all the values  in the column   Issues: How to Restrict the values in the Promt to show current year, current year-1, current year-2 when user scrolls down Solution:  In the following screen, under the "show" field select "SQLRESULTS"   use the following code Code: SELECT "Order Dates"."Order Calendar Year" FROM "BOM-RNA Analysis" where "Order Dates"."Order Calendar Year" =YEAR(CURRENT_DATE) union SELECT "Order Dates"."Order Calendar Year"-1 FROM "BOM-RNA Analysis" where "Order Dates"."Order Calendar Year" =YEAR(CURRENT_DATE) union SELECT  "Order Dates"."Order Calendar Year"-2 FROM "BOM-RNA Analysis" where "Order Dates"."Order Calendar Year" =YEAR(CURRENT_DATE) In the code "Order...
Continue reading
7884 Hits
0 Comments

What our clients are saying

  • build

    Aptude provided Build.com a Java, MySQL, Webservices and other UI based solution in the business domain of analyzing and reporting on user activities for our ecommerce website. Utilizing Omniture’s APIs to download, parse, and regenerate and upload back so that we could be more effective in our marketing. I was satisfied with their project work and delivery and would consider utilizing them for future projects.” – Dan D., Build.com

  • 1
  • 2
  • 3
  • 4

Featured Clients

  • 1
  • 2
  • 3
  • 4

Newsletter

Subscribe to our newsletter and stay updated on the latest developments and special offers!

Contact Us

Phone Number
Headquarters
1601 North Bond Street, Suite 316
Naperville, IL 60563
Atlanta Office
3355 Lenox Road Suite 750s
Atlanta, GA 30326