Very kindly one of Santa’s little helpers gave me a copy of “Mastering SAP Design Studio” by Ingo Hilgefort just before Christmas which encouraged me to use a few of the quiet days over the Christmas break to get started with Design Studio and specifically the Universe connectivity. My personal SAP background is that of someone who has come from the Business Objects perspective specifically focusing on the front end user applications. I don’t consider myself deeply technical and most definitely leave Production BI4 server installs and configuration to my Technical Architecture team and my level of SQL knowledge is let’s say 2 out of 5. So I thought maybe I personally could be a test case to see where I could recommend design studio fitting into Itelligence UK customers BI Strategies and what technical level of developer is needed to create applications. Starting Simple: Open up the client install of SAP Design Studio, and connect to a BI4.x landscape Create a new blank application Next add a new Data Source and select your objects.
It’s great to see a fully featured query panel here unlike the cut down version in SAP Dashboards (Xcelsius) After clicking OK, as O have a prompt on YEAR the following popups will appear. Don’t worry here as I did the first time, the OK button stays greyed out even after selecting a prompt value, you need to click BACK on the top left before the OK becomes available. Let the “Drag and Drop” layout design begin After dropping the CROSSTAB component on the canvas is appears only to show the Measures you have selected in the Query Panel. You need to right click on the data source and edit the initial view an add in the columns you want visible. Now to add a chart Initially this chart doesn’t look great as what I really want is just Country, Resort and Revenue. Easy you’d think?
Firstly select the chart component and in the properties pane on the left find the DATA SELECTION field under DATA BINDING. You will now go through the workflow of selecting multiple rows or columns from the result set. But, as I have a prompt in my query I get prompted again for the value, which forces a query refresh.
Not too troublesome in this example but what if the query takes many minutes to refresh? I personally find this window not yet optimised for a UNX data source, I just can’t get it to select the 3 columns I want. All you can do is select individual rows, maybe I’m missing something, any suggestions? The only way I got my desired results was to add a second data source, select the 3 columns I need and bind the chart component to this new data source with a reduced number of columns.
Instructions for Use. Leica CM1850, V2.6, English – 10/2012. 14 0471 85101 RevC. Always keep this manual near the instrument! Read carefully prior to operating the instrument! Leica CM1850.
Download the files of Leica CM1850 on this page. Contact us for any other documents regarding this product. Acceptance and Specifications. Leica CM1850 technical data EN, (PDF). Application Notes. Application Art of embedding frozen tissue EN, (PDF). Application Paper Cryoembedding EN, (PDF).
![Leica](/uploads/1/2/3/7/123736286/540706217.jpg)
I then set the data series to my companies corporate colour scheme in the additional Properties pane, some nice formatting options in there. The next logical thing was to want to build a component to activate the prompt and select a different year.
This is where I had to do some trial and error development. More errors then success I’ m afraid! I tried a few different ways and I still don’t have really what I want yet, but this give me an excuse to write a follow on blog. Attempt 1 If you just execute the Design Studio application locally using the toolbar button you are prompted for the prompt value. Nice and easy, but I don’t want to have to exit and re-enter the application just to change them prompts.
Attempt 2 So the next easiest way I found was to drag onto the canvas the Filter Panel. A great multifunctional component which I’d love to see in SAP Dashboards (Xcelsius). This filter component allows the end user during run time the ability to apply many different selection criteria. Sadly the Filter Panel appears to bind to only one Data Source so in my scenario the crosstab table will have the data restricted based on the users selection but alas not the chart. Additionally when I try to change my selection on YEAR which is my prompted object the List of Values is empty. There must be a good reason for this in the application but alas this solution doesn’t give me what I want. Attempt 3 I think this is where I will have to seek a solution using different components and Java code.
This I will have to research further and share my findings in a second part to this blog. If any of my steps are incorrect or I have missed something in the workflow please comment below so we can all learn from shared best practice. Some Ideas for quick wins:. Until there is parity of functionality in the use of components between BEx and a Universe as a data source could SAP clearly identify the data source in all learning materials to stop you trying to something new only to realise yourself it will not work with your particular data-source, a Universe for example. Some example Design Studio applications over eFashion or Island Resorts would be great to show the art of the possible inside working examples My personal conclusions so far:.
Design Studio is the first reporting tool I have used since Crystal Reports where I have needed to read a manual not just for the harder bits but even to get started with the tool, I think maybe there is a similarity in the user persona in both of them. I would go so far as to suggest that authoring content in both Design Studio and Crystal Reports should be delivered by traditional BI technical developer sitting within a BI team or BICC and any Design Studio Applications are build as part of a structured project delivery. I don’t see Design Studio application authoring being widely adopted by the mythical “Self Service End User”. It still feels you would get the most out of Design Studio if you are using SAP BW and particularly BEx Queries or SAP BusinessObjects Analysis edition for Microsoft Office as a data source at this time. I hoping this will change in the futire in line with the Dashboard Statement Of Direction. Hi Andrew, some comments: – for selecting the columns for the chart simply use the column header in the measure picker and the “add selection” button – that should do it. – it looks like you have a prompt for the Year in the Universe, which means a filter component wouldn’t necessarily help as it is a prompt, so you need to send the value to the prompt via scripting.
– to apply the filter to multiple data source the filter has a property “target data sources” where you can select those sources that should be filtered and in your case you simply need to add both sources to it. – in terms of items you can do with BEx queries or Universes, I think your confusion comes from mixing “filtering” and “prompting” in your sample application. The eBook has samples for both scenarios. Regards Ingo Hilgefort, SAP.
Or to Post -Author Message nathprabhat Forum Member Joined: 05 Sep 2006 Posts: 17 Location: India - Hyderabad Posted: Sun Sep 24, 2006 9:51 am Post subject: How to Setup eFashion DEMO Universe for WebIntelligence Hi Friends, How to Setup eFashion DEMO Universe for InfoView/WebIntelligence? What are the steps that I can follow to setup the demos for BO. Please guide. Regards Prabhat Steve Krandel Forum Devotee Joined: 24 Jun 2002.7 Posts: 12414 Location: San Jose, California Posted: Sun Sep 24, 2006 2:26 pm Post subject: Re: How to Setup eFashion DEMO Universe for WebIntelligence They should have installed when you did the intallation the first time. It's just a universe and a database.
Set it up the same way you would access any other database. The easist thing to do is to install the desktop tools on your server. The demo will then be installed. Steve Krandel Manager, Enterprise BI Tools nathprabhat Forum Member Joined: 05 Sep 2006 Posts: 17 Location: India - Hyderabad Posted: Mon Sep 25, 2006 10:40 pm Post subject: Re: How to Setup eFashion DEMO Universe for WebIntelligence Steve Krandel wrote: They should have installed when you did the intallation the first time. It's just a universe and a database. Set it up the same way you would access any other database.
The easist thing to do is to install the desktop tools on your server. The demo will then be installed. I have both the Server tools and Desktop tools are installed in the same PC. The Demos are installed in the folder C: Program Files Business Objects BusinessObjects Enterprise 6 demo IN my PC.
How can use this Universe in InfoView? Thanks Prabhat Steve Krandel Forum Devotee Joined: 24 Jun 2002.7 Posts: 12414 Location: San Jose, California Posted: Mon Sep 25, 2006 11:09 pm Post subject: Re: How to Setup eFashion DEMO Universe for WebIntelligence Open it in Designer. If it works, then you can export it to your repository. Then it will be availalble to the WebI environment. Steve Krandel Manager, Enterprise BI Tools nathprabhat Forum Member Joined: 05 Sep 2006 Posts: 17 Location: India - Hyderabad Posted: Tue Sep 26, 2006 1:33 am Post subject: Re: How to Setup eFashion DEMO Universe for WebIntelligence Steve Krandel wrote: Open it in Designer.
If it works, then you can export it to your repository. Then it will be availalble to the WebI environment. I will do this.
Prabhat Display posts from previous: or to Post -Page 1 of 1 All times are GMT - 5 Hours Jump to: Get community updates via Twitter.
Or to Post -Author Message nathprabhat Forum Member Joined: 05 Sep 2006 Posts: 17 Location: India - Hyderabad Posted: Sun Sep 24, 2006 9:51 am Post subject: How to Setup eFashion DEMO Universe for WebIntelligence Hi Friends, How to Setup eFashion DEMO Universe for InfoView/WebIntelligence? What are the steps that I can follow to setup the demos for BO. Please guide. Regards Prabhat Steve Krandel Forum Devotee Joined: 24 Jun 2002.7 Posts: 12414 Location: San Jose, California Posted: Sun Sep 24, 2006 2:26 pm Post subject: Re: How to Setup eFashion DEMO Universe for WebIntelligence They should have installed when you did the intallation the first time.
It's just a universe and a database. Set it up the same way you would access any other database. The easist thing to do is to install the desktop tools on your server. The demo will then be installed. Steve Krandel Manager, Enterprise BI Tools nathprabhat Forum Member Joined: 05 Sep 2006 Posts: 17 Location: India - Hyderabad Posted: Mon Sep 25, 2006 10:40 pm Post subject: Re: How to Setup eFashion DEMO Universe for WebIntelligence Steve Krandel wrote: They should have installed when you did the intallation the first time.
It's just a universe and a database. Set it up the same way you would access any other database. The easist thing to do is to install the desktop tools on your server. The demo will then be installed. I have both the Server tools and Desktop tools are installed in the same PC.
The Demos are installed in the folder C: Program Files Business Objects BusinessObjects Enterprise 6 demo IN my PC. How can use this Universe in InfoView? Thanks Prabhat Steve Krandel Forum Devotee Joined: 24 Jun 2002.7 Posts: 12414 Location: San Jose, California Posted: Mon Sep 25, 2006 11:09 pm Post subject: Re: How to Setup eFashion DEMO Universe for WebIntelligence Open it in Designer. If it works, then you can export it to your repository. Then it will be availalble to the WebI environment. Steve Krandel Manager, Enterprise BI Tools nathprabhat Forum Member Joined: 05 Sep 2006 Posts: 17 Location: India - Hyderabad Posted: Tue Sep 26, 2006 1:33 am Post subject: Re: How to Setup eFashion DEMO Universe for WebIntelligence Steve Krandel wrote: Open it in Designer.
If it works, then you can export it to your repository. Then it will be availalble to the WebI environment. I will do this. Prabhat Display posts from previous: or to Post -Page 1 of 1 All times are GMT - 5 Hours Jump to: Get community updates via Twitter.
Lesson 4: Formatting Reports Formatting charts Like reports, tables and cells, charts are composed of a number of elements that can be formatted separately. Web Intelligence XI provides all the chart formatting features that you are familiar with when creating professional reports. In this section of the lesson, we will explore a few of the chart formatting features that are available. Looking at chart properties To look at the chart properties.
In the Java Report Panel, build a query using the eFashion universe, and select the Year, State and Sales revenue objects. Click Run Query. Drag and drop the Vertical Grouped Bar chart template in the new report. Select the View Structure button on tool bar. The document zone switches to View Structure mode. Using drag and drop, move the Sales revenue object to the measures place holder in the chart structure. Move the State object to the dimension object placeholder and the Year object to the optional dimension object placeholder.
Click View Results. The new chart displays as shown below. Click in the bar chart to select the chart. A gray border appears around the chart to indicate that it is highlighted. Click the Properties tab of the Report Manager.
The Properties tab opens and displays the default properties set for the chart you have selected. The Chart Properties tab allows you to change the default formatting of the chart.
Formatting bar charts To make this chart more attractive and easier to read, you can reduce the font size of the Sales revenue values so that they are more in line with the rest of the chart and also modify the size of the chart. To change the font size of a chart element Continue using the report from the previous exercise. Click + next to Display in the Chart Properties tab. Adjust the chart Height and Width so that it is visually more appealing. Set the width to 700 px and the Height to 300 px. Click + in the X Axis zone to expand the X Axis properties. Click + in the Values zone.
In the Text Format zone, click the Browse button to display the Text formatting dialog box. Adjust the default font size to 6 points. The values selected are updated to reflect the changes. To display the value for each bar Continue working with the report from the previous exercise. In the Appearance zone, click + next to Data, then click + next to Values to expand the Data Values properties.
In the Show data values, click the Yes option. The data values appear above each bar in the chart. Keep the document open. Formatting pie charts In the next section, you will format a pie chart to make it more attractive and easier to read. To display the axis legend Continue using the report from the previous exercise.
Insert a new report into the document. Drag the Pie chart template onto the report. Add the State and Sales revenue objects to the template placeholders. Click View Results. The pie chart displays in the report as shown below. Click in the pie chart to select the chart.
How To Install Efashion Universe Backgrounds
A gray border appears around the chart to indicate that it is highlighted. Click the Properties tab of the Report Manager.
The Properties tab opens and displays the default properties set for the chart you have selected. In the Display zone, adjust the Height and Width of the pie chart. Set the height to 400 px and the width to 300 px. In the Appearance zone, click Yes next to the Show floor option. Change the show floor Wall colour to light yellow.
To display the data values Continue using the report from the previous exercise. Click + next to the Data zone to expand the Data values properties. In the Values zone, click Yes next to the Show data option. The data values appear as labels as shown below:. In the Values zone, click Yes next to the Show as percentages option.
The percentages appear as labels for the pie sections as shown below: Experiment with the different features available in Web Intelligence for formatting charts. Close the document without saving.