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.