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

/wp-content/uploads/2013/12/1_353564.jpg

Create a new blank application

/wp-content/uploads/2013/12/2_353565.jpg

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)

/wp-content/uploads/2013/12/3_353566.jpg

After clicking OK, as O have a prompt on YEAR the following popups will appear.

/wp-content/uploads/2013/12/4_353576.jpg

/wp-content/uploads/2013/12/5_353577.jpg

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.

/wp-content/uploads/2013/12/6_353578.jpg

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.

/wp-content/uploads/2013/12/7_353582.jpg

/wp-content/uploads/2013/12/8_353583.jpg

Now to add a chart

/wp-content/uploads/2013/12/9_353584.jpg

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?

/wp-content/uploads/2013/12/10_353588.jpg

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. I then set the data series to my companies corporate colour scheme in the additional Properties pane, some nice formatting options in there.

/wp-content/uploads/2013/12/11_353589.jpg

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.

/wp-content/uploads/2013/12/12_353590.jpg

/wp-content/uploads/2013/12/13_353591.jpg

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.

/wp-content/uploads/2013/12/14_353592.jpg

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
To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Ingo Hilgefort

    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

    (0) 
    1. Andrew Fox Post author

      Hi Ingo,

      Thanks for your comments.

      Point 1 –  I don’t seam to be able to select any column other than the measure in the Data Selection dialogue box. 1.JPG

      Point 2 – Yep my query has a prompt on it and understand your point

      Point 3 – Thanks this wasn’t obvious

      2.JPG

      Point 4 – Yep need to find time to read the ebook

      Thanks again

      (0) 
      1. Ingo Hilgefort

        hi Andrew,

        either you select a column – in that case measures or rows.

        when you select a column then you can only select a measure because the rest is defined based on your navigation status and you don’t have to worry about the characteristics as they are automatically part of the resultset when you select a column.

        Ingo

        (0) 
  2. Saints Zhang

    Hello Ingo,

    When I published it into BIP, and view it from BIP, no prompt appears.

    It means it can not be used(refreshed with different prompts) by other users.

    Right?

    Saints

    (0) 
    1. Ingo Hilgefort

      Hello Saints,

      I assume you refer to prompts in the underlying Universe.

      remember – you create a dashboard, so if you would like the user to provide input to prompts you then should build the components onto the dashboard.

      its not a “report” that will prompt for inputs.

      regards

      Ingo

      (0) 

Leave a Reply