http://
How to check available quires in server ?
http://
Note - No spaces , when typing an URL
Wednesday, January 20, 2010
Regarding Query as a Websrvices
How to check QaaWS configured ?
http://: / dswsbobje / happydsws.jsp
How to check available quires in server ?
http://: / dswsbobje / qaawsservices
Note - No spaces , when typing an URL
http://
How to check available quires in server ?
http://
Note - No spaces , when typing an URL
Tuesday, December 22, 2009
Friday, November 13, 2009
Creating a dashboard
You can follow these steps to create a dashboard using Xcelsius. For these steps, you must have data in an existing Excel spreadsheet.
To import the Excel spreadsheet
1.Open Crystal Xcelsius.
2.Close any windows within Xcelsius to create a blank work area.
3.To import an Excel file, select Data > Import Model.
4.In the Import Model dialog box, click the ellipsis to display the Open dialog box.
5.Navigate to the Excel spreadsheet. Click Open.
6.In the Import Model dialog box, click OK.
To build the visual model
After you import the spreadsheet, you must add components.
A component can be from the following categories:
Charts
Single Value
Selectors
Maps Library
Art & Background
Other
Text
Web Connectivity
If it is chart please follow the steps….
1.Select View > Components > Charts
2.Select the component and click on the work area to add the component.
3.Right click the component and select Properties from the menu.
4.The Properties window may have different tabs based on the components selected. The General tab controls the minimum required properties for the component to function. The tab contains the Data Source link properties that link the component to the Excel model.
5.Provide a description in the Chart subtitle, or make it blank.
6.In the Data Range box, click the Cell Reference icon.
7.A representation of the Excel model is activated with a dialog box that you use to select the desired range. Select a data range.
8.Click OK.
To import the Excel spreadsheet
1.Open Crystal Xcelsius.
2.Close any windows within Xcelsius to create a blank work area.
3.To import an Excel file, select Data > Import Model.
4.In the Import Model dialog box, click the ellipsis to display the Open dialog box.
5.Navigate to the Excel spreadsheet. Click Open.
6.In the Import Model dialog box, click OK.
To build the visual model
After you import the spreadsheet, you must add components.
A component can be from the following categories:
Charts
Single Value
Selectors
Maps Library
Art & Background
Other
Text
Web Connectivity
If it is chart please follow the steps….
1.Select View > Components > Charts
2.Select the component and click on the work area to add the component.
3.Right click the component and select Properties from the menu.
4.The Properties window may have different tabs based on the components selected. The General tab controls the minimum required properties for the component to function. The tab contains the Data Source link properties that link the component to the Excel model.
5.Provide a description in the Chart subtitle, or make it blank.
6.In the Data Range box, click the Cell Reference icon.
7.A representation of the Excel model is activated with a dialog box that you use to select the desired range. Select a data range.
8.Click OK.
Publish the dashboard
When you are satisfied that the dashboard is working, you publish the dashboard.
Select File > Export.
Select Microsoft PowerPoint (PPT) / PDF/Word, which is a .ppt/.doc/.pdf file.
In the Export dialog box, provide the name and location of your dashboard.
Open the ppt /.doc/.pdf file to view the dashboard.
Select File > Export.
Select Microsoft PowerPoint (PPT) / PDF/Word, which is a .ppt/.doc/.pdf file.
In the Export dialog box, provide the name and location of your dashboard.
Open the ppt /.doc/.pdf file to view the dashboard.
Preview the work area
You can test the visual model to be sure that the components display the intended data. Xcelsius lets you test your dashboard by enabling a Macromedia Flash (SWF) preview mode. The preview lets you validate your visual model and to test the look and feel of the dashboard.
Click Preview.
To exit the Preview mode, click Preview.
Crystal Xcelsius
Introduction
Crystal Xcelsius complements all types of Portal initiatives, Business Intelligence programs, Executive Dashboards, Balanced Scorecard projects, Marketing Reports, and day-to-day reporting and presentation requirements. Xcelsius does this by letting users participate in the report creation process and analysis.
Crystal Xcelsius Designer 2008 enables to create interactive presentations from Managed Enterprise Data. Using the new Live Office Connector in Crystal Xcelsius Designer and the new Live Office Web Services in BO Enterprise XI R2, can create and refresh Xcelsius Visualizations against managed Enterprise data.
This document outlines the process of creating a dashboard. You import a snapshot of an Excel file that lets you build a visual model. You link the component to the Excel data and then publish the model as a PDF, MS-PPT, MS-Word and SWF file apart from BO Platform.
Crystal Xcelsius is designed to work with Excel XLS files. The Excel spreadsheets can be any size, but the amount of data in your dashboard can affect the overall performance.
Prerequisites
This content is for the technically-oriented user. You should have a solid understanding of the following technologies
Excel A basic understanding of how to navigate and how to create formulas.
Xcelsius A basic understanding of Xcelsius and experience in creating dashboards in Xcelsius. You should be familiar with the work area.
Xcelsius File The XLF file that is created during the development of an Xcelsius dashboard or data presentation. The file is the working development file that is used in the work area.
Excel model -the source spreadsheet that contains the data that is represented in the dashboard.
Visual model - The visual model is a blank area on which you add the components that visually represent the data that you import from the Excel model. The visual model is saved as an XLF file.
Dashboard The dashboard is the finished product of the Xcelsius development. After you have created the visual model and saved it as a Flash file, then you have created a dashboard.
Component The object that gives the dashboard its utility and purpose. You build the visual model by adding a component and then linking the component to the data from the Excel model
You should understand how Crystal Xcelsius works with Excel and why you should connect to an external data source.
The first step to creating a Crystal Xcelsius dashboard is to import an existing Excel spreadsheet into the Crystal Xcelsius work area. The imported spreadsheet has all of the data, formulas, formatting, mapping and any other features and loads the information into an Xcelsius-embedded Excel spreadsheet as an XLF file. You do not need the original Excel spreadsheet after you import it.
After you create the dashboard in the work area, Crystal Xcelsius converts it into a PDF file. The finished dashboard does not contain the entire spreadsheet. The PDF prototype file only contains the range of cells and any dependencies that you have selected for each component.
When a user opens the dashboard, all of the necessary data is either contained within the dashboard or is dynamically retrieved by connecting to an internal source.
Crystal Xcelsius complements all types of Portal initiatives, Business Intelligence programs, Executive Dashboards, Balanced Scorecard projects, Marketing Reports, and day-to-day reporting and presentation requirements. Xcelsius does this by letting users participate in the report creation process and analysis.
Crystal Xcelsius Designer 2008 enables to create interactive presentations from Managed Enterprise Data. Using the new Live Office Connector in Crystal Xcelsius Designer and the new Live Office Web Services in BO Enterprise XI R2, can create and refresh Xcelsius Visualizations against managed Enterprise data.
This document outlines the process of creating a dashboard. You import a snapshot of an Excel file that lets you build a visual model. You link the component to the Excel data and then publish the model as a PDF, MS-PPT, MS-Word and SWF file apart from BO Platform.
Crystal Xcelsius is designed to work with Excel XLS files. The Excel spreadsheets can be any size, but the amount of data in your dashboard can affect the overall performance.
Prerequisites
This content is for the technically-oriented user. You should have a solid understanding of the following technologies
Excel A basic understanding of how to navigate and how to create formulas.
Xcelsius A basic understanding of Xcelsius and experience in creating dashboards in Xcelsius. You should be familiar with the work area.
Xcelsius File The XLF file that is created during the development of an Xcelsius dashboard or data presentation. The file is the working development file that is used in the work area.
Excel model -the source spreadsheet that contains the data that is represented in the dashboard.
Visual model - The visual model is a blank area on which you add the components that visually represent the data that you import from the Excel model. The visual model is saved as an XLF file.
Dashboard The dashboard is the finished product of the Xcelsius development. After you have created the visual model and saved it as a Flash file, then you have created a dashboard.
Component The object that gives the dashboard its utility and purpose. You build the visual model by adding a component and then linking the component to the data from the Excel model
You should understand how Crystal Xcelsius works with Excel and why you should connect to an external data source.
The first step to creating a Crystal Xcelsius dashboard is to import an existing Excel spreadsheet into the Crystal Xcelsius work area. The imported spreadsheet has all of the data, formulas, formatting, mapping and any other features and loads the information into an Xcelsius-embedded Excel spreadsheet as an XLF file. You do not need the original Excel spreadsheet after you import it.
After you create the dashboard in the work area, Crystal Xcelsius converts it into a PDF file. The finished dashboard does not contain the entire spreadsheet. The PDF prototype file only contains the range of cells and any dependencies that you have selected for each component.
When a user opens the dashboard, all of the necessary data is either contained within the dashboard or is dynamically retrieved by connecting to an internal source.
Subscribe to:
Posts (Atom)