TM1 Forum

Hi all,
can somebody please tell me how to extract data from qlikview reports into tm1 cube. i googled it all and what i found out was tm1 data into qlikview and not the other way round.
thankyou.

Never extract data from reports. Instead, find out which database(s) Qlik is connecting to and pull data straight from there via ODBC.

qml wrote:Never extract data from reports. Instead, find out which database(s) Qlik is connecting to and pull data straight from there via ODBC.

thanks . i will try .. but what if we dont have access to that database and only qlikview is accessible then what ?

talsam wrote:what if we dont have access to that database and only qlikview is accessible then what ?

I don't know your circumstances, but it is very unlikely that there is a hard (technical) reason why you can't access the source database. Most likely it's a soft (political/organisational) one. Personally, I would make it my mission to convince whoever is blocking this access to change their mind. You have some good arguments on your side: simplicity, modularity, maintainability, resilience.

Maybe you don't even need direct access to the database - maybe a data extract generated by the database itself would be enough.

We've all been in situations when we had a choice - do things the easy way or the right way. Almost every single time doing them the right way is best for everyone in the long run. I'm not saying to never be pragmatic, but compromising on architecture should never be done without a really, really good reason that is understood and accepted by everyone involved.

You could request the Qlikview developer to drop data to a file for you as part of the Build Script in Qlikview. It's not very hard to do in Qlik.