...• Building and editing queries with Web Intelligence • Performing on report analysis with Web Intelligence • Filtering Queries using conditions, prompts etc., • Using Combined Queries and merging dimensions • Displaying data in various formats (Ex: Tables, Charts etc.,) Advanced Reporting: • Calculations, Formulas and variables • Ranking Data, using Alerters to highlight data, Formatting numbers and Dates • Understanding Calculation Contexts • Web Intelligence Functions, Operators and Keywords • Calculating values with Smart Measures Universe Designer: • Designer and Universe Fundamentals • Creating a schema with Tables and Joins • Resolving Join problems in a schema • Defining Classes, Objects, hierarchies, using cascading list of values for hierarchies • Testing the universe • Working with OLAP universes Xcelsius 2008: • Application Overview • Creating and Updating Xcelsius visualizations • Using Xcelsius components ( Chart, Containers, Selectors etc.,) • Exporting Xcelsius visualizations to various applications (Power point, PDF, Flash • Creating templates, Alerts and Dynamic visibility • Using Data Manager ( Creating and configuring connections) • Live Office Connections, Query As A Web Service (QWAAS), XML data Connections Crystal Reports: • Report Design Concepts • Designing Optimized Web Reports • Building queries, Filters and prompts • Sorting, Grouping and Totaling of data • Accessing data sources,Creating and updating OLAP reports ...
Words: 462 - Pages: 2
...1. 2. 3. 4. Problem Solving Using Access 2007 LEARN IN G OUTCO ME S Describe the process of using the Query Wizard using Access. Describe the process of using the Design view for creating a query using Access. Describe the process of adding a calculated field to a query using Access. Describe the process of using aggregate functions to calculate totals in queries using Access. 5. Describe how to format results displayed in calculated fields using Access. Introduction A query is a tool for extracting, combining, and displaying data from one or more tables, according to criteria you specify. For example, in a book inventory database, you could create a query to view a list of all hardcover books with more than 500 pages that you purchased in the past five months. In a query, you can sort information, summarize data (display totals, averages, counts, and so on), display the results of calculations on data, and choose exactly which fields are shown. You can view the results of a query in a tabular format, or you can view the query’s data through a form or on a report (which is covered in Plug-In T8, “Decision Making Using Access 2007”). In this plug-in, you will learn how to use the Query Wizard and Query-By-Example (QBE) tool to solve problems using Microsoft Access 2007. Creating Simple Queries Use the Query Wizard to create a select query. A select query displays data from a table or tables, based on the fields that you select, but it does not sort or filter the...
Words: 1224 - Pages: 5
...CREATING QUERIES Lesson 9 Introduction The real power of an Access 2007 database is in the ability to pull data for quick analysis, which is what happens when you run a query. Queries allow you to retrieve information from one or more tables based on a set of search conditions you define. Access 2007 will display your results in their very own table that you can analyze and manipulate further. This lesson will explain how to plan a query using a three-question planning process. You will learn how to use the Query Design command to run the query, as well as how to modify the query to hide fields or other information in your query results. Finally, it will show you how to save the query for later use. Using Queries Queries retrieve information from one or more tables based on a set of search conditions that you set up and then combine that information in a way that is easy for you to analyze. If you have used an Advanced Filter in Access 2007, then you have already run a very basic query on only one table. If you want to pull data from more than one table, though, you will need to use either the Query Design command or the Query Wizard. Before using the Access 2007 query tools, it is important to plan out the query using a logical process. Otherwise, you may not get the results you expect. Planning a Query There are three questions you need to answer when you are planning a query: What do you want the results to look like? Identify every field or bit of information...
Words: 2519 - Pages: 11
...Software: Comprises of the Database Management System (DBMS) and application programs. The DBMS is at the heart of any database system. It allows users to store information in an ordered manner for timely and quick retrieval from the database. 4. Procedures: Instruction and rules that govern design and use of databases e.g. starting and stopping db, making backups, handling failures 5. Users: Four categories of database users ▪ Database Designers - designs conceptual and logical database ▪ Application Developers - writes application programs that use the database ▪ Data and Database Administrator ▪ End - user - interacts with the system from an on-line terminal by using Query Languages etc....
Words: 3345 - Pages: 14
...CATEGORY -- 1D) --Prompt Creating Table Category; create table CATEGORY ( catcode varchar2(4), catname varchar2(30), primary key (catcode) ); --Prompt Creating table STATE; create table STATE ( statecode varchar2(4), statename varchar2(30), primary key (statecode) ); --Prompt Creating Table SUPPLIER; create table SUPPLIER ( suppcode number(4), suppname varchar2(30), city varchar2(30), statecode varchar2(4) , primary key (suppcode), foreign key (Statecode) References STATE ); --Prompt Creating Table PRODUCT; create table PRODUCT( prodid number(4), descr varchar2(30), sellingprice number(6,2), purchasecost number(6,2), weight_kg number(6,2), suppcode number (4), catcode varchar2(4), primary key (Prodid), foreign key (Suppcode) References SUPPLIER, foriegn key (Catcode) References CATEGORY ); 1E) DROP TABLE CATEGORY CASCADE CONSTRAINTS; DROP TABLE STATE CASCADE CONSTRAINTS; DROP TABLE SUPPLIER CASCADE CONSTRAINTS; DROP TABLE PRIDUCT CASCADE CONSTRAINTS; --Prompt Creating Table Category; create table CATEGORY ( catcode varchar2(4), catname varchar2(30), primary key (catcode) ); --Prompt Creating table...
Words: 679 - Pages: 3
...helps you understand what table columns deserve an index through a series of exercises on a database schema. You do not type SQL in this assignment, but rather identify which columns deserve indexes, the type of index it deserves, and why. Correct placement of indexes is absolutely critical to database performance. All but the smallest of databases would have terrible performance if no indexes were assigned to any of its table columns. An index is a physical construct that serves two purposes – speeding up data retrieval and enforcing uniqueness. Indexes are not modeled in logical entity-relationship diagrams, because indexes do not operate at the logical level of abstraction, as do tables and table columns. While the primary purpose of creating an index is to speed up data access, modern relational DBMS also support a type of index that additionally enforces a uniqueness constraint. A uniqueness constraint can be assigned to a table column directly, or is indirectly assigned to a table column when it is assigned a primary key constraint. While a uniqueness constraint is a logical construct, many modern relational DBMS physically implement this constraint through an index. You might reasonably ask the question, “Why not simply add indexes to every column in the schema?” After all, then we would not need to concern ourselves with index placement. The primary reason is that while indexes speed up reading from the database, indexes slow down writing to the database. Indexes associated...
Words: 1460 - Pages: 6
...Planning and Creation of a Fleet Truck Maintenance Database for Huffman Trucking In creating a database, the most vital steps are identifying the table elements. Upon analysis of the Entities and Attributes for Fleet Truck Maintenance form, the elements of the database tables can be identified. In a table, or relation, the entities and attributes of a table define the structure of a database. An entity is an object of importance about which data can be captured. An attribute is the information that describes the entity. When creating the tables for the Huffman Trucking Fleet Truck Maintenance, entities and their relationships must be taken into consideration (Koenke & Auer, 2010). Selection of Entities and Attributes In the Entities and Attributes for Fleet Truck Maintenance document, the entities and their attributes are clearly defined. The entities are listed in all capital letters. The entity’s respective attributes are listed below the entity. For example, for the entity “Parts_Inventory_Issues”, the attributes listed in the document are: * Transaction ID * Issue Date * Purchase Price * Quantity In creating the table, the attributes must be examined to ensure that the table is organized logically and contains no chances of redundancy. Because of this, the entities and attributes used in the actual database will be modified from the attributes listed in the document. Repeating attributes will be deleted or reorganized to ensure logical structure...
Words: 2654 - Pages: 11
...Open Object Business Intelligence Release 1.0 Tiny SPRL 2009-04-09 CONTENTS i ii Open Object Business Intelligence, Release 1.0 I 1 2 Part 1 : Introduction Goal of the project What is for User? 2.1 2.2 2.3 For the end-user: . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . For the administrator user: . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . For the developer: . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 7 9 9 9 9 11 12 15 3 OLAP 3.1 Who uses OLAP and Why? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 Terminologies II 5 6 Part 2 : Architecture Schema Components 6.1 6.2 6.3 6.4 6.5 6.6 The Cube . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . The CLI interface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . The Cube Definition . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . The Web Client . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . The OpenOffice plugin . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . The Open ERP interface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 19 21 21 21 21 22 22 22 23 25 26 7 Extra libraries 8 Introduction to the OpenObject Module 8.1...
Words: 9931 - Pages: 40
...Microsoft® Office Access 2007 ™ ALL-IN-ONE DESK REFERENCE FOR DUMmIES ‰ by Alan Simpson, Margaret Levine Young, Alison Barrows, April Wells, Jim McCarter Microsoft® Office Access 2007 ™ ALL-IN-ONE DESK REFERENCE FOR DUMmIES ‰ Microsoft® Office Access 2007 ™ ALL-IN-ONE DESK REFERENCE FOR DUMmIES ‰ by Alan Simpson, Margaret Levine Young, Alison Barrows, April Wells, Jim McCarter Microsoft® Office Access™ 2007 All-in-One Desk Reference For Dummies® Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030-5774 www.wiley.com Copyright © 2007 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, (317) 572-3447, fax (317) 572-4355, or online at http://www...
Words: 190131 - Pages: 761
...can be utilised * Discuss the difference between a database and the other applications * Understand how databases are organised and operated * Create a simple database and view database content in various modes * Create a table, define and modify fields and their properties; enter and edit data in a table * Sort and filter a table or form: create, modify and run queries to retrieve specific information from a database * Understand what a form is and create a form to enter, modify and delete records and data in records * Build queries to retrieve and sort data * Create routine reports * Build and print reports for regular and ad hoc reporting of data Terminology | | Database | A database is a collection of related information which is organised into a series of rows (called records) and columns (called fields) that are populated with data. | | Data | Data is a series of individual facts. | | Information | Information is the result of the organisation, processing, and interpretation of data. | | Database Management System (DBMS) | The computer program used to manage and query a database. | | Data Normalisation | A method used in designing the structure of your database. In...
Words: 20896 - Pages: 84
...MS Access 2003 Introduction to Data Base A database can help you enter data easily, find it quickly, use it to create labels or mailings, and summarize it in printed and online reports. Benefits of Using a Database A database is much more than just a list or table. It gives you true command of your data, enabling you to retrieve it, sort it, analyze it, summarize it, and report results in moments. It can combine data from various files, so that you never have to enter information twice. It can even make data entry more efficient and accurate. A key benefit of Database is avoiding the complications of multiple lists. Let's say that you're the secretary of a large hiking club. You have a list of recycling volunteers, a list of holiday party volunteers, addresses for newsletter labels, a membership list, and so on. Suppose that a club member, who appears on a number of lists, changes her e-mail for the second time this year. With only a set of lists, you'd have the tiresome job of changing that information everywhere it occurs. With a well-structured database, you'd have to change it only once. The database takes care of everything else. If you're just working with 10 or so items, then you'll probably want to create a simple list, perhaps as a worksheet in Microsoft Excel or a bulleted list or table in Microsoft Word. If your data is more complex, or changes frequently, then an Access database gives you an advantage. Relational Data base & MS Access Relationships...
Words: 11316 - Pages: 46
...The database development process * Query and application development tools * CASE tools for database analysis and design * Tables, attributes and relationships * Primary and foreign keys * Relational integrity constraints * Manipulating data: selection, projection, join, union, intersection, difference * An integrated, active data dictionary * The query optimizer * Developing the logical data model * Mapping the data model to the relational model * Specifying integrity constraints * Defining the data in the data dictionary * Capturing entities, attributes and identifiers * Describing relationships: one-to-one, one-to-many, many-to-many * Optional and mandatory relationships * Resolving many-to-many relationships for implementation * Generating the SQL to build the database * Reverse engineering to capture the design of an existing database * SQL Programming Language Introduction 1 Days * Write SQL code based on ANSI/ISO standards to build Microsoft SQL Server or Oracle database structures * Update database content with SQL and transaction handling * Retrieve data with filter conditions and from multiple tables using various types of join * Process data with row and aggregate functions * SQL Server Introductory Courses * SQL Server Introduction 1Days * Create and administer SQL Server 2012 or 2014 databases * Write Transact-SQL queries to retrieve and manipulate data *...
Words: 1010 - Pages: 5
... mysql> CREATE TABLE example ( id INT, data VARCHAR(100) ); Query OK, 0 rows affected (0.03 sec) Creating a table with a particular storage engine MySQL provides a variety of different table types with differing levels of functionality. The usual default, and most widely used, is MyISAM. Other storage types must be explicitly defined: mysql> CREATE TABLE example_innodb ( id INT, data VARCHAR(100) ) TYPE=innodb; Query OK, 0 rows affected (0.03 sec) Note that beginning with MySQL 4.1 ENGINE=innodb is the preferred method of defining the storage type. Use SHOW CREATE TABLE (see below) to check that MySQL has created the table as you defined it. Creating a table with auto_increment Often you'll want to be able to automatically assign a sequential value to a column: mysql> CREATE TABLE example_autoincrement ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, data VARCHAR(100) ); Query OK, 0 rows affected (0.01 sec) mysql> INSERT INTO example_autoincrement (data) -> VALUES ('Hello world'); Query OK, 1 row affected (0.01 sec) mysql> SELECT * FROM example_autoincrement; +----+-------------+ | id | data | +----+-------------+ | 1 | Hello world | +----+-------------+ 1 row in set (0.01 sec) Creating a table with the current timestamp Often it's useful to have an automatic timestamp on each record. The...
Words: 881 - Pages: 4
...helps you understand what table columns deserve an index through a series of exercises on a database schema. You do not type SQL in this assignment, but rather identify which columns deserve indexes, the type of index it deserves, and why. Correct placement of indexes is absolutely critical to database performance. All but the smallest of databases would have terrible performance if no indexes were assigned to any of its table columns. An index is a physical construct that serves two purposes – speeding up data retrieval and enforcing uniqueness. Indexes are not modeled in logical entity-relationship diagrams, because indexes do not operate at the logical level of abstraction, as do tables and table columns. While the primary purpose of creating an index is to speed up data access, modern relational DBMS also support a type of index that additionally enforces a uniqueness constraint. A uniqueness constraint can be assigned to a table column directly, or is indirectly assigned to a table column when it is assigned a primary key constraint. While a uniqueness constraint is a logical construct, many modern relational DBMS physically implement this constraint through an index. You might reasonably ask the question, “Why not simply add indexes to every column in the schema?” After all, then we would not need to concern ourselves with index placement. The primary reason is that while indexes speed up reading from the database, indexes slow down writing to the database. Indexes associated...
Words: 2196 - Pages: 9
...BI – Migration from Business Objects to Cognos |Umesh Ashok | |Tata Consultancy Services | |Mumbai | |umesh.ashok@tcs.com | ABSTRACT This White paper describes the POC Experience of migrating reports from Business Object XI R2 to Cognos BI 8.3 It highlights the challenges, solutions and best practices implemented for seamless transition TARGET AUDIENCE Cognos Architect and Developers of BO to Cognos Migration project PRE REQUISTIC Knowledge of Cognos BI 8.3, Business Objects XI R2 and RDBMS Databases. INTRODUCTION XYZ uses Business Object as a reporting tool to develop and deliver reports to the business to analyze the data. XYZ wants to upgrade these BO reports into Cognos reports using Cognos 8 BI suite. Existing BO Reports presented quite a challenge for migration because of many reasons like diverse formats of reports and multiple interfaces. Cognos BI environment is available with the XYZ. Prime goal to migrate BO reports...
Words: 2384 - Pages: 10
