As a developer I was involved in collecting the requirements from business end user, according understood the business needs and involved in designing the universe for sales department ,As a first step we understand the structure of the universe and depending upon the fact tables n dimension tables created classes ,objects ,defined joins ,cardinalities ,created derived tables, custom Hierarchies .

Involved in resolving the join path problems like loops in universe. Check the structure of universe, used @functions to create Predefined connections and prompts to filter the data at universe level. Test the universe and export it to repository. Deployed reports accordingly to run on daily/weekly/monthly basis using webintelligence for sales department

Used different functions like sort,filters ,break,sections to create webi reports for sales and finance department

implemented dense rank features in bo reports, Created complex webi and crystal reports using merged dimensions, Linking two reports at report level using hyperlink, Applied slice and dice and drill down options for multidimensional purpose: .

* Using crystal reports Created subreports and pass date parameters to sub reports and use them in the selection criteria * Used various functions to develop crystal reportsWorked on rolling dates and how to subtract one datetime field from another and displaydays hours,minutes and seconds.Here I used date function syntax: [DateDiff(intervaltype,StartDateTime,EndDateTime]

Environment: my environment their are 500 Business End Users and 4 report Developers and Two Universe Designer and one Administrator

Structure: I was involved in designing the universe from different multiple datamodels like starschema,snowflakes schema
Joins between tables:
Join is a bidirectional relationship between 2 tables, A join is a condition that links the data in seperate but related tables.
Fact table: : A fact table contains statistical information about transactions. For example, it may contain figures such as Sales Revenue or Profit.
In a universe, most but not all, measures are defined from fact tables

Involved in linking facttables:Example. custumer fact table is connected to loan fact table via customer_id, and each record in loan fact table is uniquely identified by a primary key on cod_acct_no. Similarly customer table can be connected to Savings fact table through customer id. OLAP - Online Analytical Processing, which deals with analysis of data. It has to deal with historical data too (for analysis purpose) Not updated frequently. If required bulk update is allowed.

OLTP - Online Transactional Processing, which deals with transactions. For e.g. withdrawals at ATM machines. It involves many transactions. The databases have to be updated more frequently after the successful completion of a transaction.

Dimension table:
Cardinalities: Checked the cardinalities between the tables, Detect cardinalities in joins options in the Database tab of the Options dialog box, Designer detects and retrieves the cardinalities of the joins Cardinality expresses the minimum and maximum number of instances of an entity B that can be associated with an instance of an entity A. The minimum and the maximum number of instances can be equal to 0, 1, or N.

Because a join represents a bi-directional relationship, it must always have two cardinalities.
There are two main methods for detecting or editing cardinalities: * the Detect Cardinalities command
* the Edit Join dialog box

YOU MAY ALSO FIND THESE DOCUMENTS HELPFUL

...﻿Data mining and OLAP are the most common BusinessIntelligence technologies. The term BusinessIntelligence refers to computer based methods to identify and extract useful information from business data. Online Analytical Processing commonly known as OLAP provides summary data and generates rich calculations. OLAP is a class of systems that provide answers to multidimensional queries. OLAP is typically used inbusiness reporting for sales, marketing and various such domains. OLAP enables the users to view the data interactively from multiple perspectives.
On the other hand, Data mining helps discover hidden pattern or trend in data to support a conclusion. As the name suggests, unlike OLAP that operates at a summary view, Data mining operates at detail level. For instance, if walmart would like to identify the trend of products sold during a holiday season, data mining would help them answer that question based on historic data.
Although, OLAP and data mining operate on data to gain intelligence, the main difference lies on how they operate on the data. OLAP tools provide multidimensional data analysis and summaries of the data. On the contrary data mining focuses on ratios, patterns and influences in the set of data. OLAP and data mining can complement each other. OLAP might point out problems with sales of a specific product for walmart for this month in particular...

...In today’s business environment, every organization has developed a unique ways of gaining a competitive advantage over its rival and these unique ways can be furthermore described as a business process. An effective business process can be adequately administered by the use of certain software tools and systems known as BusinessIntelligence (BI).
BusinessIntelligence represents the tools and systems that play a key role in strategic planning of an Organization. These tools are used to gather, store, access and analyze corporate data for better decision making, cut cost, more profits and stability through improved efficiency.
A company may illustrate businessintelligence in the areas of customer profiling, customer support, market research, market segmentation, product profitability, statistical analysis, inventory and distribution analysis and so more. In this academic paper, I will explicitly elaborate on these areas of businessintelligence used by today’s companies, its implementation, benefits and possible or potential problems.
BusinessIntelligence tools analyze raw data into meaningful information by the help of the management for future decision making. The management devises special approaches such as data/text mining, data warehousing, online analytical processing (OLAP),...

...﻿
Cloud BusinessIntelligence
Abstract
Cloud computing is the technology which gives efficiency to an organization by efficient use of the computing resources. Tamer, C., Kiley, M., Ashrafi, N., & Kuilboer, J. (2013) said cloud computing gives its services as Infrastructure as a service (IaaS), Platform as a service (PaaS) and Software as a service (SaaS). Businessintelligence (BI) makes organization intelligent and stand firmly in the competitive market by delivering the right information at the right time. Mixing of the cloud computing with business intelligent makes BI affordable and easily available. Cloud computing allows to access the businessintelligence applications easily and the other advantages are deployment speed, scalability, elasticity and accessibility. Many vendors are looking forward to develop strategies and solutions. There are many challenges to overcome when migrating from traditional BI to cloud BI. The cloud businessintelligence influences the operational and financial factors of the organization and it plays an important role in times of economic crisis in the market. The cloud BI is adopting slowly around the world and technology is going to be a trend in future.
Key Words: Cloud computing, Businessintelligence, agility, cloud strategy,...

...Communications of the Association for Information Systems (Volume13, 2004) 177-195
177
BUSINESSINTELLIGENCE
Solomon Negash Computer Science and Information Systems Department Kennesaw State University snegash@kennesaw.edu ABSTRACT Businessintelligence systems combine operational data with analytical tools to present complex and competitive information to planners and decision makers. The objective is to improve the timeliness and quality of inputs to the decision process. BusinessIntelligence is used to understand the capabilities available in the firm; the state of the art, trends, and future directions in the markets, the technologies, and the regulatory environment in which the firm competes; and the actions of competitors and the implications of these actions. The emergence of the data warehouse as a repository, advances in data cleansing, increased capabilities of hardware and software, and the emergence of the web architecture all combine to create a richer businessintelligence environment than was available previously. Although businessintelligence systems are widely used in industry, research about them is limited. This paper, in addition to being a tutorial, proposes a BI framework and potential research topics. The framework highlights the importance of unstructured data and discusses the need to...

...Transformation through BusinessIntelligence Deployments
Businessintelligence (BI) is a broad category of applications and technologies for gathering, storing, analyzing, and providing access to data to help enterprise users make better business decisions. BI applications include the activities of decision support systems[->0], query[->1]and reporting, online analytical processing (OLAP[->2]), statistical analysis, forecasting, and data mining[->3].
Businessintelligence applications can be:
 Mission-critical and integral to an enterprise[->4]'s operations or occasional to meet a special requirement
 Enterprise-wide or local to one division, department, or project
 Centrally initiated or driven by user demand
This term was used as early as September, 1996, when a Gartner Group report said:
By 2000, Information Democracy will emerge in forward-thinking enterprises, with BusinessIntelligence information and applications available broadly to employees, consultants, customers, suppliers, and the public. The key to thriving in a competitive marketplace is staying ahead of the competition. Making sound business decisions based on accurate and current information takes more than intuition. Data analysis, reporting, and query tools can help business users wade through a sea of data to synthesize valuable...

...Business analytics and data mining provided 1-800-Flowers with all of the following benefits except:
Select one:
a. more efficient marketing campaigns
b. increased mailings and response rates
c. increased repeat sales
d. better customer experience and retention
On the commercial side, the most common use of data mining has been in ________ sectors.
Select one:
a. manufacturing and heath care
b. online retail and government
c. R&amp;D and scientific
d. finance, retail, and health care
The term data mining was originally used to ________.
Select one:
a. describe the process through which previously unknown patterns in data were discovered
b. include most forms of data analysis in order to increase sales
c. All of the above
d. describe the analysis of huge datasets stored in data warehouses
In an article in Harvard Business Review, Thomas Davenport (2006) argued that the latest strategic weapon for companies is ________.
Select one:
a. customer relationship management
b. analytical decision making
c. Online auctions
d. E-commerce
Data mining is tightly positioned at the intersection of many disciplines. Those disciplines include all of the following except:
Select one:
a. statistics
b. management science
c. information systems and databases
d. logistics
Why has data mining gained the attention of the business world?
Select one:
a. All of the above
b. Consolidation and...