When a “one to many” join linked by another “one to many” join in a serious of tables called as Fan Trap. Like the below example, Customer is having multiple Loan account and each Loan having Multiple Collateral which is “one to Many” & “One to Many” join in a series of tables. Let see…
Trap issues are common problem in relational database schemas in which a join path returns more data than expected. There is no specific option to find trap issues in universe designer and it can be identified only by looking the join relation between tables visually. There are 2 different types of trap issues can occur…
Current Business intelligence & Data Visualization market has lots of tools and have done some case study to compare their features especially for Data visualization tools feature comparison for QlikView, Tableau and SAP BI Dashboard (Xcelsius). Each tools has its own specialism and you can choose any tools which fits for your requirement. Data Visualization…
Problem Description: Daily transactions are loaded into database on daily basis along with Date. There is a requirement to schedule the reports on each and Every Quarter end and display the data for 3 separate tab for each month of the quarter and send it to users. Example -1, Refresh the report on April 01,…
Derived table is not a physical in database however its logical table created in Business Objects Universe using SQL. Derived table can be considered like views in database where its structure is defined using SELECT statement. Create Derived table in universe Designer: Either goes to Insert – Derived table or right click in the universe…
Duplicate Context Imagine you have a context which has huge number of joins selected and you want to create another context for same joins along with some more joins. Click the existing context and right click from any of the joins selected. New context pop up window will appear along with all the selected joins.…
Hierarchies and Drilling are inter-related wherein hierarchies should be defined in universe to do drilling in the report. Drilling hierarchy determines the drill path from high-level summary data to low-level detailed data. Drilling is used to perform analysis based on trends in the required data that can be recognized when looking at low-level detailed data.…
I have listed some of Business Intelligence tools which are emerging in BI and analytics Market. SAP Business Objects SAP Net weaver SAS BI Qlikview Targit Bi Suite Spotfire Jaspersoft IBM Cognos Microsoft Bi Microstrategy Bi Information Builders Webfocus Oracle Bi (OBIEE) Panorama Actuate Pentaho Tableau Style Intelligence Yellowfin BI RapidMiner SpagoBI Eclipse BIRT Knime
Information Design Tool (IDT) is a metadata design environment that enables a designer to extract, define, and manipulate metadata from relational and OLAP sources to create and deploy Business Objects universes. Universes created using the information design tool can be used by the following SAP Business Objects data analysis and reporting applications starting with version…
The term “cloud” is essentially a representation for Internet and Business / marketers have further commercialized the phrase “in the cloud” to refer to software, platforms and infrastructure that are sold “as a service”, i.e. remotely accessible through the Internet. Typically, the service providers has actual energy-consuming servers which host products and services from a…
DWBI castle 