Webi Report development navigations

CREATING QUERY ,SAVING AND EDITING QUERY	For creating query  you need to select Datasource as Universe or whatever available as per your requirement from LEFT HAND SIDE of webi screen and drag and drop Dimensions, Detailed objects and measures from LEFT HAND SIDE of query panel in to result panel. Now click on run query (Top of the RIGHT HAND SIDE), click on save list  BI PLATFORM.
	For editing query select Data access tab ---->edit  select required objects drag and drop from LEFT HAND SIDE of query panel into RIGHT HAND SIDE of query panel and run query and notice your new objects in Available object panel .Now drag and drop new objects  from LEFT HAND SIDE to RIGHT HAND SIDE.
Properties for a query	such as limiting the number or rows of data retrieved, setting security to allow or prevent other users from editing the query, and changing the order of prompts. open query----> Data access tab......>Edit......>query properties......> then you can see limits the number or rows of data retrieved and types of data to retrieve i.e retrieve duplicate records and retrieve non empty rows and prompt processing order , For security purpose allow other users to edit all queries ,For refresh reset context on refresh Now run query to refresh data
View the SQL or MDX query	When you run a query, Web Intelligence retrieves the data by running a script consisting of a series of SQL or MDX statements. SQL statements are used by relational databases, while MDX statements are used by OLAP databases. Web Intelligence allows you to view and edit the SQL generated by a query, and even copy and paste it to another application. You can view MDX queries but you cannot edit them open query----> Data access tab......>Edit......>view script here you can edit the SQL query by using Custom query script or copy and paste it to another application. Note: You can't edit  SQL script when query includes optional prompts.
you can view and modify Web Intelligence Rich Client application properties from BI launch pad	For this Preferences menu : Viewing ....>change the measurement unit from centimeters  to inches Locale: It determines how webi displays data such as date and number formatting Drill: It refers to the ability to interactively filter a report for example clicking on a particular year value to see only the data for that year.
In Web Intelligence you can display and modify properties that are assigned by default to the Web Intelligence document	open query ....>properties......>Document ; Now you can see number of options : Enhanced viewing :It optimize the report for onscreen viewing. Refresh on open: It is ensure that the latest data is displayed each time the reports open .  Permanent regional formatting :It is permanently applies the current date, time and currency locale to report. Use query drill down: It enables drilling in the data.  Enable query stripping :It removes unused objects from the query when the query is refreshed.  Auto merge dimensions: This option synchronizes dimensions that have the same name but are derived from separate queries.  Extend merge dimension values :This option  effects the way dimensions are joined when they are merged.
Usage of copy and turn into charts	Once you have created a table or chart in your report with the appropriate dimensions and measures, you can copy that report object and then make changes to the duplicate. you will copy the table in a report and then convert the duplicate table into a chart. Report element tab .....>turn into.....>Vertical table, cross tab, column, line, pie, crosstab
Add a report to a document	A Web Intelligence document can contain multiple reports on separate tabs. you will add another report to a document. Page setup tab...>add report...>Rename tab.
How to publish the Webi documents to the CENTRAL MANAGEMENT SERVER:	NOTE: When you work in Web Intelligence from BI launch pad, you can only save Web Intelligence documents to the CENTRAL MANAGEMENT SERVER. Open Query....>click on save list....>publish to.....>expand public folder,,,>Webi document folder...>click on advanced...>click on description...>enter description...>enter report name at NAME and then save expand public folder: when you publish to the Central Management Server, by default webi publish to your my favorites folder. only you can access documents published to your my favorites  folder .To allow other users to access the document, you must publish it to the public folders click on advanced: To help other users understand its purpose. Here some other options also u have 1)refresh on open 2)Permanent regional formatting 3) save for all users: i.e. other users also have authorized to open it. 4)Remove document security: to allow the documents to be viewed when disconnected from the Central Management Server
Save a document as other formats	You can save your Web Intelligence documents locally or in the SAP Business Objects Business Intelligence platform in the standard WID format, as a PDF document, or as an Excel spreadsheet click on save...>save as....>in filename box give any name like sales.wid...>in files of type choose excel or pdf what ever you want
Add another query to a document	A single Web Intelligence document can contain multiple queries open any webi document which is already having a report and click on data access tab...>click new...>select from universe...>select ur universe...>select...>drag and drop required objects into result panel....>run query....> now u can notice that a new table added to the report. now click on available objects(LEFT HAND SIDE) you can notice all the objects from both queries. Connecting to Data Sources:----
Change the data source on which a query is based	Web Intelligence allows you to change the data source used to create a document. This can be useful in instances where you are switching from test to production environments, changing between universes the cover different functional areas but are based on the same data source, or converting documents built on the old UNV format to the new UNX format. Here you will change the data source from the old eFashion universe to the new UNX format. Open query...> data access tab...>tools...>change source list...> select query...>select specify new data source. Or u can choose existing one depends up on requirement..>select a data source ..>select required universe...>click on select ...>next ...> finish. Observe here list of objects mapping correctly if it’s not you can browse..
In Web Intelligence, you can create reports based on Microsoft Excel spreadsheets.	Open webi....>select excel from choose data source to create a new document...> efashion.xlsx...>open...>next here you can restrict columns or rows if you want....>run query observe report.
Combine multiple queries	Combined queries are queries that work together to create a single result. There are three different operators that you can use to combine queries. The union operator returns all the data from both queries. The intersect operator returns only the rows that match both queries. The minus operator returns all the data from the first query minus any data that matches the second query. In this tutorial, you will create a combined query.
Merge dimensions from different universes	You can create queries based on multiple universes in Web Intelligence. In situations where those universes share similar data, you can merge the dimensions so that data from both sources can be displayed in the same table open query.....>data access...>data provider....>edit...>add query...>select required universe...>drag and drop objects...>run query...>select any option like 3rd...>drag and drop object in to Right Hand Side of report(table)...>observe report...> ...>click on merge...>select  at least 2 Objects...>o.k..>observe report
Connect to an Analysis view	You can use the results from an Analysis work space, exported as an Analysis view, as a data source for a Web Intelligence document. Note: Here u can’t choose the dimensions and measure to use in your query. as these are predefined by what was already available in the analysis work space when it was exported as a view. Note: that all items are automatically added to the table. but u can remove the unwanted columns or delete the entire table and create a new from scratch, using only those report objects u want.
Turn vertical table to horizontal to cross tab table :	Click the boarder of the table to select it...>tools....>turn into...>Horizontal table....>or cross tab.... If u want modify any table then turn in to.....>more transformations...>select & delete.
Deleting column in table	select header of the column ...>c.m...>delete. Or select header of the column...>click on cut.(top).
Adding charts to Web Intelligence reports	Create a chart: Insert a pie chart a pie chart showing sales revenue by state: Click on charts...>select pie...> click in the report panel...>c.m chart outer boarder...>edit...>select desire ones...>click on o.k.
Format chart to indicates the data value for each slice	c.m on chart inner boarder...>format boarders...>data values...>show data labels ...>o.k. now u can see the chart values outside. If u want chart values inside...>c.m chart inner boarder...>format boarders...>data values...>data type..>select value....>data position..>inside..>o.k. Now u can see the values inside of the pie chart
Turn a table into column chart	select table(top level): select tools: turn into column...>observe column chart if u feel difficult to find values then click on undo..> turn into more transformations...>select columns under table....>under category axis delete some columns & leave state, year. under value axis...>select sales revenue(measures)..>under regional color...>select year..>o.k. now observe column chart
Create a chart for hierarchical data	In order to create a chart that displays hierarchical data for a Bex query, you must first display the levels of the hierarchy that you want to show, as you cannot drill down into the hierarchy within the chart. Open report select table column..>c.m..>expand descendant..>click the boarder of the table..>turn into..>column observe the column chart
Create charts with hierarchical dimensions	22)Web Intelligence enables you to create charts based on hierarchical dimensions, and to drill to navigate the levels of the hierarchy within the chart. Create a column chart to display open orders by country: chart..>insert column chart drag and drop required objects. Now the chart currently displays the top level of hierarchy Now if u want to display hierarchy..>c.m on column bar..>hierarchical navigation...>all....>expand all hierarchy
Format a data series in a chart: i.e u can edit any part or specific part in pie chart or any chart:	Select one part of the pie chart....>c.m...>format data series...>select custom radio button..>click the color list..>select any color...>show data label..>o.k. Now you can see the changed color.
You can create links(hyper link) to external web sites from within your Web Intelligence documents	Click on report element tab...>click on linking tab...>click on cell in report plot area...>click hyper link tab.....>add hyper link...>click on text box...>type url and then click on parse...>click the target window list...>select new window..>o.k..>click hyper link in report plot area.
In the D HTML client for Web Intelligence, you can create hyperlinks in your document that open another document.	Select store name column without header...>click on linking tab...>document....>add document link...>browse...>select required report...>select and open...>select refresh on open...>o.k..>now click on any store name then u can see the details of particular store.
Drill down table	You can set up your Web Intelligence documents so that you have the ability to drill down into the data based on navigation paths that are set up in the universe to create hierarchies between dimensions, such as country, state, and city. Open webi report or drag and drop required objects in to result objects....>click on scope of analysis panel.(left top)...> click on master perspective(now u can see scope of analysis in Right Hand Side)...>display by navigation paths......>click on scope level list(Right Hand Side downside in scope of analysis) ...>select the desired level like 3 or 2.(now u can observe scope of analysis panel with fields)..>run query now u have to drill down
Drill down the query	Analysis tab...> drill...>start drill...>select any state(now observe on top), select any year(observe on top)...>now u can see quarters Q1,Q2...instead of years and city names instead of states...>on top u can check  the state lists and years and u can  select however u want ...>if u want u can drill up(in header of column u can see the option)
To copy the report	You can use snapshot option :drill...>snapshot...>now u can observe the copy report. To Disable drill down  functionality ...>drill..>end drill.

Read More

Difference between the Universe Design Tool and Information Design Tool

The information design tool is a new modeling tool for the semantic layer that enables you to manipulate metadata from relational and OLAP sources, and to create and deploy SAP Business Objects universes. Classic universe features available in Universe Designer have been redeveloped and incorporated in the information design tool.

This document is a reference guide for users that have worked with previous versions of Universe Designer, which has been re branded as the universe design tool, to identify where to find classic universe features in the Information design tool, and to define the differences between the two semantic layer tools.

Universe Design Tool	Information Design Tool
Quick Design Wizard	No equivalent
	Relational universe creation workflow:
	1.		Click File > New > Project.
	2.		Click File > New > Relational Connection.
	3.		Click File > New > Data Foundation.
	4.		Click File > New > Business Layer.
	OLAP universe creation workflow:
	1.		Click File > New > Project.
	2.		Click File > New > OLAP Connection.
	3.		Click File > New > Business Layer.
File > Import	Click File > Retrieve a Published Universe.
File > Export	Universe publishing workflow:
	1.		From within Local Projects, right-click the Connection (*.cnx) and
			click Publish Connection to a Repository.
	2.		From within Local Projects, right-click the Business Layer (*.blx) and click
			Publish > To a Repository.
File > Metadata Exchange	No equivalent
File > Parameters > Definition > Description	From within a Data Foundation (*.dfx), click Properties.
File > Parameters > Definition > Connection	Relational connection workflow:
	1.		Click File > New > Relational Connection.
	OLAP connection workflow:
	1.		Click File > New > OLAP Connection.
File > Parameters > Summary		From within a Data Foundation (*.dfx), click Properties > Summary.
		From within a Business Layer (*.blx), click Properties > Summary.
File > Parameters > Links		No equivalent
File > Parameters > Strategies		No equivalent
File > Parameters > Controls		From within a Business Layer (*.blx), click Properties.
File > Parameters > SQL		From within a Data Foundation (*.dfx), click Properties.
		From within a Business Layer (*.blx), click Properties.
File > Parameters > Parameter		From within a Data Foundation (*.dfx), click Properties > Parameters.
		From within a Business Layer (*.blx), click Properties > Parameters.
File > Print		From within the Local Projects view, right-click a Business Layer (*.blx) and click Print.
		From within the Local Projects view, right-click a Data Foundation (*.dfx) and click Print.
		From within a Data Foundation (*.dfx), click Print View to Bitmap.
Edit > Undo Action		Click Edit > Undo Action.
Edit > Find/Replace		Click Window > Find/Replace.
		From within a Business Layer (*.blx), click Show/Hide Search Panel.
		From within a Data Foundation (*.dfx), click Show/Hide Search Panel.
Edit > Hide Item(s)		From within a Business Layer (*.blx), right-click an object and click Change State.
Edit > Object Properties > Definition		From within a Business Layer (*.blx), double-click an object.
Edit > Object Properties > Properties		From within a Business Layer (*.blx), double-click an object and click Advanced.
Edit > Object Properties > Advanced		From within a Business Layer (*.blx), double-click an object and click Advanced.
		From within a Business Layer (*.blx), right-click an object and click Change Access
		Level.
Edit > Object Properties > Keys		From within a Business Layer (*.blx), double-click an object and click Keys.
Edit > Object Properties > Source		From within a Business Layer (*.blx), double-click an object and click Source
Information		Information.
Edit > Object Format		From within a Business Layer (*.blx), right-click an object and click Edit Display
		Format.
Edit > Rename Table		From within a Data Foundation (*.dfx), right-click a table and click Edit.
Edit > Edit Derived Table		From within a Data Foundation (*.dfx), right-click a Derived Table and click Edit.
View > Arrange Tables		From within a Data Foundation (*.dfx), click Auto Arrange Tables.
View > Refresh Structure	From within a Data Foundation (*.dfx), click Detect > Refresh Structure.
View > Table Values	From within a Data Foundation (*.dfx), right-click a table and click Show Table
	Values.
View > Change Table Display	From within a Data Foundation (*.dfx), right-click a table and click Display.
View > Number of Rows in Table	From within a Data Foundation (*.dfx), click Detect > Row Count.
View > Grid Lines/Page Breaks	No equivalent
View > List Mode	No equivalent
Insert > Tables	From within a Data Foundation (*.dfx), click Insert > Tables.
Insert > Stored Procedures	No equivalent
Insert > Derived Table	From within a Data Foundation (*.dfx), click Insert > Derived Table.
Insert > Alias	From within a Data Foundation (*.dfx), click Insert > Alias.
Insert > Join	From within a Data Foundation (*.dfx), click Insert > Join.
Insert > Context	From within a Data Foundation (*.dfx), click Aliases and Contexts > Insert Context.
Insert > Class/Subclass	From within a Business Layer (*.blx), click Insert Item > Folder.
Insert > Object	From within a Business Layer (*.blx), click Insert Item > Dimension.
	From within a Business Layer (*.blx), click Insert Item > Measure.
	From within a Business Layer (*.blx), right-click a dimension and click New > Attribute.
Insert > Condition	From within a Business Layer (*.blx), click Insert Item > Filter.
Insert > Candidate Objects	No equivalent
Insert > User Objects	No equivalent
Insert > Universe	No equivalent
Tools > Connections	From within a Data Foundation (*.dfx), click Connection.
	From within a Data Foundation (*.dfx), click Connection > Change Connection.
	From within Repository Resources, click Session > Connections.
Tools > Hierarchies	From within a Business Layer (*.blx), click Navigation Paths.
Tools > List of Values	From within a Business Layer (*.blx), click Parameters and Lists of values.
	From within a Data Foundation (*.dfx), click Parameters and Lists of values.
Tools > Aggregate Navigation	From within a Business Layer (*.blx), click Actions > Set Aggregate Navigation.
Tools > List of Aliases	From within a Data Foundation (*.dfx), click Aliases and Contexts.
Tools > List of Derived Tables	No equivalent
Tools > Query Panel	From within a Business Layer (*.blx), click Queries.
Tools > Automated Detection	From within a Data Foundation (*.dfx), click Detect.
Tools > Check Integrity	From within a Business Layer (*.blx), click Check Integrity. Click Window > Check Integrity Problems.
Tools > Login As	From within the Repository Resources view, click Insert Session.
Tools > Change Password	No equivalent
Tools > Manage Security	Click Window > Security Editor.
Tools > Options	Click Window > Preferences.
Window > Arrange/Split	From within a Data Foundation (*.dfx), click Insert > View.

Read More