topic QV can pull data from CUBES? in QlikView

QV can pull data from CUBES?

Wed, 28 Oct 2009 10:38:01 GMT

Hi All,

I have a scenario that I want to pull data from CUBES of SQL.Is it possible to pull the data from CUBES.Please

let me know the same

Thanks & Regards

Jai

QV can pull data from CUBES?

Anonymous — Wed, 28 Oct 2009 11:33:16 GMT

Hi Jai,

There is no direct support for building or executing MDX-queries in QlikView. The following MDX-query (for the demo-database included with SQL 2005) will not work if you cut-and-paste it into QlikView:

SELECT { [Measures].[Sales Amount], [Measures].[Tax Amount] } ON COLUMNS,
{ [Date].[Fiscal].[Fiscal Year].&[2002], [Date].[Fiscal].[Fiscal Year].&[2003] } ON ROWS
FROM [Adventure Works]
WHERE ( [Sales Territory].[Southwest] )

However, by using openrowset() in SQL, it is possible to encapsulate the MDX-query in a standard SELECT statement. In this example Microsoft OLEDB for Olap Services is used to query Analyis Services:
SQL SELECT * FROM
openrowset('MSOLAP.3','DATA SOURCE=localhost;Initial Catalog=Adventure Works DW',
'SELECT { [Measures].[Sales Amount], [Measures].[Tax Amount] } ON COLUMNS,
{ [Date].[Fiscal].[Fiscal Year].&[2002], [Date].[Fiscal].[Fiscal Year].&[2003] } ON ROWS
FROM [Adventure Works] WHERE ( [Sales Territory].[Southwest] )')

Note: Support for openrowset is disabled by default in SQL 2005 Server

Re: QV can pull data from CUBES?

Thu, 07 Feb 2013 14:07:08 GMT

Did Uou check O-delta™?

"O-delta™ by DataForce Ltd. is the most comprehensive Solution today for companies to dramatically cut down Time & Money of Connection, Migration & Integration of OLAP (mdx.) data cubes to any QlikView’s models, from months/ weeks to days/ hours !!! Http://www.dataforce-solutions.com The Benefits are: • Minimum need of skills/ knowledge of the current OLAP cubes’ structure • Leverages OLAP cubes development investments • Intuitive, integrated & consolidated view of all BI information as a front end • Mobile availability of old and new BI applications"

http://www.youtube.com/watch?feature=player_embedded&v=dlb6nf0w6TQ