Solved: connector issue - Qlik Community

ksk278074 · ‎2018-09-10

HI all,

I am trying to load the data using SAP bex connector, but which is not possible because using bex's connector we can able to fetch 5lacks records in single load.

So in this case how to load the data from DB to qliksence using the bex connector?

is it possible to fetch the montly data by using filer condtion like where month = 'jan'., if yes , where to writhe the filer connection in qliksense

.

Please suggest me on the same .

thanking you in advance

mats_olin · ‎2018-09-11

If you want to limit the data you extract with a BEx query the BEx query needs to have 'Query Variables' (defined in SAP BEx Query Designer or HANA Studio if BW Query). In my example you can filter on a date range so set the date range so in that case you need to set the date range so that the result set is small enough for your BW Application server to handle. If you don't have 'Query Variables' in your select dialog in Sense you need to talk to someone who can add a variable to the BEx query:

View solution in original post

vamsee · ‎2018-09-10

Yes. You can filter down the data at a month or day level.

Then use incremental load for concatenating the QVD's. I do it at a day level.

Example:

LET CalendarDay = '20180302';

SET ThousandSep='';

SET DecimalSep='.';

SET TimeFormat='HH:mm:ss';

SET DateFormat='yyyy-MM-dd';

SET OpenUrlTimeout=28800;

Table:

Load

*

FROM [http://localhost:8085/?name=**** & CalDay=$(CalendarDay)]

(txt, codepage is 65001, embedded labels, delimiter is ',', msq, no eof);

Store Table into Table_$(CalendarDay ).qvd (qvd);

ksk278074 · ‎2018-09-10

Thanks for the reply.

Can you please explain more in the script level? it would be very useful for me.

vamsee · ‎2018-09-10

If you want to manually filter down to one day or one month you do it using Bex.

If you want to automate the script and use incremental load you might have to convert it to Mdx.

ksk278074 · ‎2018-09-10

is it possible to convert the Mdx? if yes how? and

FROM [http://localhost:8085/?name=**** & CalDay=$(CalendarDay)]

in the above example u can load the data from excel and call the day function

in my case i need to load the data drom db then thta time where i need to writhe call function.?

ksk278074 · ‎2018-09-10

++ can you please provide me sample script or sample example.

vamsee · ‎2018-09-10

I am sorry I don't have a sample right now.

These might help

https://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/Clients/SAP-BEx-connec...

https://www.youtube.com/watch?v=iOxwEhxCDx0

Hoping Michael mto‌ would be able to help you further on this.

Michael_Tarallo · ‎2018-09-10

Hi Guys - I am not sure about the BEX connector and Qlik Sense - I sent this to our PM for a quick check.

Regards,
Mike Tarallo
Qlik

ksk278074 · ‎2018-09-10

Thanks for the response Michael

waiting for your reply for the same..

Thanks in advance ...

ksk278074 · ‎2018-09-10

hi Michael,

Any update on the same?

connector issue

Related Topics