SAP Design Studio - "Unload" a datasource

[former_member358236]

Hello dear community,

I have a question and hope that you can help me with this:

There's a method/function for datasources called "loadDatasource()". I just need a function which does the opposite of that, so something like "unloadDatasource()". Does somebody know a workaround for this or a way how I can unload a datasource?

Thanks and Regards,

Vu

[Vidhya]

Hi Vu,

As Mustafa said is right there is option to no unload the data source in the script level. where you can do,

1. reload DS

2. clear all filter from the datasource - once you click on reset.

Regards,

Vidhya

[former_member197738]

Hi Pham,

Not sure if you are trying to achieve swapping of data-source on a visualizing component basically making it dynamic.

• DS_1
• DS_2
• Infochart.setdatasource(DS_1); // or DS_2 on the fly swap

[MustafaBensan]

Hi Vu,

Lumira Designer 2.0 has an unloadDataSource() method. You may wish to consider upgrading if you're on DS 1.6.

Regards,

Mustafa.

[former_member358236]

Hi Mustafa,

thanks for the quick reply.

I don't have to opportunity to upgrade it to Lumira Designer 2.0 because I'm working with Desgin Studio in a cloud (SaaS, Software as a Service).

Do you have a workaround or a way how I can do that in Design Studio in mind?

Thanks and Regards,

Vu

[MustafaBensan]

Hi Vu,

Can you clarify what you mean when you say you are working with "Design Studio in a cloud"? If you mean you are connecting to a virtual desktop that is being hosted by a third-party provider, then I would think that as the customer, you should be able to request that they upgrade it to Lumira Designer 2.0 for you.

By the way, what type of data source are you using? BEx, Universe, HANA?

And specifically what is it that you are trying to achieve by "unloading" a data source?

Regards,

Mustafa.

[former_member358236]

Hi Mustafa,

it is a BISAS platform (BISAS = BI Software as a service) and it's like a web page, where I can use all the BI applications that are provided by our customer. I don't think that I can request an upgrade because this platform is used by thousands of other people and not only me.

I'm using an Universe (Oracle database), that I created in SAP Information Design Tool.

The reason why I want to "unload" a datasource is as follows:

My application / report has 400.000 rows for every datasource. So on start up I set the "Load in Script" of all datasources to "true" so that the application has a good performance because it doesn't have to load all data until I say so in a script. The datasources are only loaded if a filter is applied by the user. And I just want to unload all datasources again if the user cancels the filter (by resetting all filter criteriums), so that not all 400.000 rows of every data sources have to be loaded.

Regards

Vu

[former_member202257]

Can you apply filter to only the relevant datasources when the user cancels the filter? You can then control the execution of the datasources.

[MustafaBensan]

So does that mean you currently have a global filter that is applied against all loaded data sources?

Also, what is the desired effect on the application UI if you could "unload" a data source?

[former_member358236]

Hi Mustafa,

yes thats right. I have implemented a filterpanel which filters all datasources and therefore all diagrams in the report.

As I already told you in one post earlier: The desired effect is that, IF the user cancels the filterpanel (reset Filter criteriums) and applies -> that not all datasources load all data.

[MustafaBensan]

Hi Vu,

There is no possibility of "unloading" the data sources. Currently, when you clear the filters of a loaded data source the result of course will be that all data will be loaded. But when you say the desired result is "IF the user cancels the filterpanel (reset Filter criteriums) and applies -> that not all datasources load all data", does that mean you only want to clear the filters of SOME of the already loaded data sources, or do you mean that you simply want to preserve the current filter state upon cancellation?

It would be helpful if you posted some screenshots of your application and described the desired results in the context of those screenshots.

Regards,

Mustafa.