Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, everyone
I am the greenhand here. Recently, I am dealing with a case for QV which need to extract the data from BW.
One question, when I extract the data, can I extract the hierarchy levels in the BW? I tried it was possible for extract one dimension's hierarchy but failed in multiple dimension.
Second question, is that possible extracted the aggregated data (calculated data from BW by formula) rather than the base data into Qlikview?
Hope my question is clear.
Hi
If you use the QV SAP OLAP connector and connect to a BeX query you can extract the calculations within the query and also the hierarchies (one per characteristic), to extract multiple hierarchies you will need multiple LOAD statements.
you can also use the SQL connector and extract the 'H' table which contains the hierarchy data at base level, finally the Extractor connector can extract hierarchy data also (from base data)
thanks
Ian
Hi, Lan
Thank you for your reply. I use the QV SAP OLAP and connect to BW query. Now I fix the problem for extract calculations and hierarchies, but I have another problem, if I want to load update data, do I need to reload the script again? Because it takes too long. How can I only add the update data? The same, when i miss a dimension to extract, do I have to reload the entire data again??? (seems that I can't add dimension menual from the BW system)
And another problem make me fussy is that during the extraction process, I can't use debug function to see where goes wrong. Sometimes, after a long time extraction, it just show up"can't read the data from...." I really don't know what's going wrong.
Can u explain me what's the multiple LOAD statements?
Really thanks for your help
Hi
below is a link to a sample document for delta loads with the OLAP connector:
http://community.qlik.com/docs/DOC-1583
an example of multiple load statements to extract data from OLAP cubes is detailed in the OLAP connector section of the SAP connector manual
thanks
Ian
Hi lightbridge,
we had the same problem. We are able to download just one hierarchy per dimension.
this was one of the reasons, why we are now working with the Theobald Connector for QlikView (Xtract QV), because this tool has a sophisticated connector for the BW Hiearchies, where all types of hierarchies are supported without restrictions.
I am really very glad to work with this tool from Theobald.
thanks
sanil
Hi,
does anyone has a coding example how to extract BW hierarchies?
Regards Lars