Adhoc analysis template missing in 1.6 & how to skip databrowser screen in generic analysis template

[former_member237405]

Hi Design Studio Team,

question 1:

now in design studio 1.6, there is no adhoc analysis template option, it was there earlier in 1.3 version of design studio..

                 Adhoc analysis template is needed beacuase we can not apply Multiple filter together in generic analysis as like adhoc analysis template,

In Adhoc Analysis template, we can select filter on multiple dimensions and then can apply all together from single popup window – see below screen shot 1

                 In Generic analysis there is no such option of selecting filter on multiple dimensions and then apply all together from one single popup window, but we need to do right click on each dimension separately & then have to select filter members..– see below screen shot 2

question 2:

in generic analysis template, I have already hard coded datasource under folder data source > Data Binding > Data Source as shown in screen shot 3,

and now i want to skip datasource browser pop-up where we select source system & data source (Example: source system = HANA & datasource  = HANA live data source) while executing generic analysis template, can we skip this using modifying/commenting event: Application > Events > 'On Startup' something like as mentioned below? and commenting event: technical component > connection > events > 'on datasource browser confirmed' or what is the correct wasy of skipping this?

Screen shot 1 - Adhoc analysis template ( can select filter on multiple dimensions and then can apply all together from single popup window )

Screen shot 2 - Genric Analysis template ()

Screen Shot 3 - hard coded data source at Data Binding of data source folder

Br, Dushyant.

[MustafaBensan · Accepted solution]

Hi Dushyant,

In answer to your questions:

1)  Your observation is accurate, the Adhoc Analysis template has been deprecated as of Design Studio 1.6, in preference for the Generic Analysis template.  If you want to apply the same type of filtering as shown in your Screen Shot 1, then simply add the Filter Panel component to the template;

2)  If you want to skip the data browser on start-up in order to use the hard-coded data source, it should be sufficient to comment out the "DATA_SOURCE_FUNCTIONS.open_source_dialog();" statement in the on_startup function of the START_FUNCTIONS global script object as shown in the screen shot below:

You should also change the Load in Script property of the data source from true to false.

Regards,

Mustafa.

[former_member237405 · Accepted solution]

Thanks Mustafa,

Regarding Answer 1,

I added filter panel with visibility false on top of navigation panel with visibility true, how to toggle between this two panel? by default required navigation panel but if needed then required filter panel..

Regarding Answer 2,

I unable to check your suggested solution as i already applied SP01 of 1.6 version in which it seems sap has already taken care of skipping logon screen at function opensource.dialog if datasource is already hardcoded in genric analysis template.

open_source_dialog is modified to check if datasource is hardcoded then skip logon screen, so from SP01 i guess your suggested 2 steps is not required, right?

DATA_SOURCE_FUNCTIONS.open_source_dialog();

/* Load DataSource */

DS_1.loadDataSource();

/* DataSource is initial, no DataSource is assigned and loaded --> show Open Source Dialog */

/* DataSource is assigned and loaded --> skip Open Source Dialog */

But How to skip this ln data discovery & visualization template as in 1.6 SP01 still if we hardcode datasource then still datasource browser screen is coming for selecting source system & datasource..

Regards, Dushyant.

[former_member237405 · Accepted solution]

Hi,

Regarding Answer 2, in Genric Analysis template, skipping initial screen of selecting source system & datasource if datasource is already hardcoded:

Now in Generic analysis template, I Guess from Design Studio 1.6, SP01, open_source_dialog() function as shown below, now its checking if datasource is already hard coded then initial screen will be automatically skipped? Right?

/* Load DataSource */

DS_1.loadDataSource();

/* DataSource is initial, no DataSource is assigned and loaded --> show Open Source Dialog */

if (DS_1.isInitialized() != true) {

  /* possibility to start the app via URL parameter */

  /* no URL parameter set */

  if (XQUERY == "") {

  DATA_SOURCE_FUNCTIONS.load_system_ids();

  DATA_SOURCE_FUNCTIONS.load_recently_used_datasources();

  LAYOUT_CONTAINER.setVisible(false);

  DIALOG_CONTAINER.setVisible(true);

  GRID_DIALOG_CONNECTION.setVisible(true);

  DIALOG_CONNECTION.setVisible(true);

  /* URL parameter is set */

  } else {

  /* assign DataSource directly and skip Open Source Dialog */

  if (XTYPE == "BW") {

  DS_1.assignDataSource(XSYSTEM, DataSourceType.QUERY, XQUERY);

  }

  else {

  DS_1.assignDataSource(XSYSTEM, DataSourceType.INFOPROVIDER, XQUERY);

  }

  DATA_SOURCE_FUNCTIONS.create_identifier_via_XQUERY();

  LAYOUT_CONTAINER.setVisible(true);

  DIALOG_CONTAINER.setVisible(false);

  GRID_DIALOG_CONNECTION.setVisible(false);

  DIALOG_CONNECTION.setVisible(false);

   }

/* DataSource is assigned and loaded --> skip Open Source Dialog */

} else {

  LAYOUT_CONTAINER.setVisible(true);

  DIALOG_CONTAINER.setVisible(false);

  GRID_DIALOG_CONNECTION.setVisible(false);

  DIALOG_CONNECTION.setVisible(false);

}

How can we do same, skipping initial data browser screen for selecting source system & datasource, In Data Discovery & Visulaization template in Desing studio 1.6 SP01?

Dushyant.

[MustafaBensan · Accepted solution]

Hi Dushyant,

Can I as what is the business use case for hard-coding the data source in the Data Discovery and Visualization template?  This template is intended for Self-service storyboarding based on multiple data sources selectable by the user, rather than for a pre-defined data source.

Regards,

Mustafa.

[former_member237405 · Accepted solution]

Hi Mustafa,

Answer:

I am planing to give this Data Discovery and Visualization template with single BW query or HANA live view with more than 50 fields, sub module wise, so user can play around from those fields only,

so wanted to hard code the data source in the the Data Discovery and Visualization template,

Else if we can restrict source system with set of selected BI query or HANA live query, ex: for HANA connection have 1000 HANA live views, but i need to give them selected 20 HANA live view only instead of 1000 view currently to avoid confusion about which HANA live view to use

question 1:

ALso user will get source system selection option without maintaining connection in thier GUI or same for HANA connection?

question 2:

Also Map & Trallies chart type are not available compare to Generic analysis

Regards, Dushyant.

[MustafaBensan · Accepted solution]

Hi Dushyant,

Normally you would restrict the data sources available to the user from the source system via backend security.  If you can't do this for some reason then given that you only have a small list of HANA views of about 20, you could modify the template to include a dropdown list containing the HANA views or BW Queries available to the user.  This dropdown could be populated as follows:

1)  Hard-code the views/queries in the list.  Not ideal from a maintenance perspective but a quick solution;

2)  Develop a HANA view/BW Query which takes a parameter such as User as input and returns the list of available views/queries for that user.

Regarding your questions:

1)  Once the Design Studio is deployed to a platform, the user will not have to maintain any local connections for access;

2)  I noticed the Heat Map and Trellis Charts where not available in the Chart Type Picker compared to the Generic Analysis, although I'm not sure why this was the case at first glance.  I'll take another look if I get the chance.

Regards,

Mustafa.

[former_member237405 · Accepted solution]

Thanks Mustafa,

We will try your suggested solution of using drop down in Data discovery & visualization template & to populate dropdown with suggested two solution and will let you know result later..

Regarding below point if you get chance to look at then please convey:

Point 1: missing chart in Data discovery & visualization template

I noticed the Heat Map and Trellis Charts where not available in the Chart Type Picker compared to the Generic Analysis, although I'm not sure why this was the case at first glance.  I'll take another look if I get the chance.

Point 2: Filter panel toggle

I added filter panel with visibility false on top of navigation panel with visibility true, how to toggle between this two panel? by default required navigation panel but if needed then required filter panel..

Regards, Dushyant..

[former_member662726 · Accepted solution]

Replying with my different SID to track

[former_member662726 · Accepted solution]

Dear Mustafa,

Regarding Self Service BI template Data discovery and visualization template, you have suggested two approach for restricting BW query & HANA Live query - 1st using security & 2nd using dropdown.

But Data discovery and visualization template is only available in local & BI platform mode accrodin to sap guide page nuber 48 https://websmp101.sap-ag.de/~sapidb/011000358700000390622012D.pdf, then how to access BW query and HANA Live view for this template apart from Local mode (User will not access Desing studio report using Local mode so)

NW mode for BW query- not supporting this template

HANA mode for HANA live/view - same not supporting this template

So only option to access BW query & HANA live/view using BI platform? how? directly or we need to create first BO report (ex: webi on top of BW query or webi on top of HANA live via IDT) which can only input to this template using this mode?

Regards, Dushyant.

[TammyPowlas · Accepted solution]

On the last part, have you tried creating the template locally and uploading to the BI platform?

[former_member662726 · Accepted solution]

Thanks Tammy for reply,

Here uploading mean import export as below?:

for BW query & HANA Live query to make available in Data discovery template,

first we need to connect local mode & create report on top of BW query & HANA live view and then do export (or export as template) from Application menu and then switch to BI platform mode and simply import exported template to use it in Data Discovery template? its great if this will work..

---

Also what is general best practice for using Generic Analysis & Data Discovery template on top of BW query and HANA live view, is my below understanding correct?

1A. for BW query to Generic analysis template - use Netweaver mode where generic analysis template available

1B for BW query to Discovery template - use first Local mode to create report then export it - then switch to BI Platform mode and import this template

2A for HANA Live view to Genric analysis template or Discovery template - as both these template are not supported in HANA mode I guess - use first Local mode to create report then export it - then switch to BI Platform mode and import this template

Regards, Dushyant.

[TammyPowlas · Accepted solution]

Best practice, in general, in my view, is to open / create the templates on the BI platform and use that with your related connections - make it simple

As for which template to use, it depends on your use case  - see

[former_member662726 · Accepted solution]

Thanks Tammy,

I am able to log-on in design studio with HANA & Netweaver mode (and able to run BW query on Portal)..

I wanted to check in BI Platfrom mode for both template that if I can directly connect both BW query and HANA Live view in this BI Platform mode as like in local mode but getting below error while trying to log-in in BI platform mode.

- So once this error get resolved & once I will log-on via BI platform mode, can I able to connect both HANA Live & BW query in this mode?

- in this mode, report will get executed on which environment?, BO?, as like in Netweaver mode its get run on portal?

Regards, Dushyant.

[TammyPowlas · Accepted solution]

Looks like the Design Studio add-on has not been installed on your platform; please do that first

Then you need to set up connections in the platform to BW/HANA

[former_member662726 · Accepted solution]

Thanks Tammy.. Ok I will install BIP Add on 1.6 with SP01 Patch 2, and will check and let you know..

you said you need to set up connections in the platform to BW & HANA - mean from BO CMC? OLAP Connection for BW from CMC & HTTP Connection for HANA from CMC?

if my above understanding is correct then using this BI platform mode, Design studio report will execute on BO Launchpad right (as like In Netweaver mode it run on Portal)?

Br, Dushyant.

[TammyPowlas · Accepted solution]

Yes, I mean CMC

[former_member662726 · Accepted solution]

So only to create two OLAP connection from BO CMC one to HANA DB & one to BW application,

and this both connection will be visible in data binding section of Design studio's BI platform mode,

and then we can directly browse all bw query & hana live view in Design studio BI platform mode using this two BO CMC connection, right?

[TammyPowlas · Accepted solution]

Yes, what you are saying makes sense - you can also check the videos at sap.com/learnbi

[former_member662726 · Accepted solution]

thanks for clarify and link.

Just question, for hana live, only BI platform is the option to connect hana live with standard template (as hana mode don't have standard template),

but for BW query there is 2 option, 1st Netweaver mode --> run on portal directly & create ivew there and 2nd BI platform mode --> run on BO platform so may need to create CUID ivew to link with portal, for BW query which option/mode (1st or 2nd) is faster performance wise? (Netweaver mode directly running bw query on portal)

[former_member662726]

Hi team,  I want to deploy Design studio report on top of BW query in SAP enterprise portal, this can be done using HANA mode,

which mode we should use for BW query - BI Patfrom mode or HANA mode, according to performance consideration?

Regards, Dushyant.