Discussion Board for collaboration on QlikView Scripting.
I am currently trying to integrate datas from an SQL source on QV
I proceed as follow:
I went to file > Edit script
Here is the problem: when I tried to reload my file I got an error message.
Please see the attached document for more details.
You are trying to connect a Analysis server Cube.
You should chose
Microsoft OLE DB Provider for SQL Server
If you want to connect to a OLAP source as an analysis cube. Your connection should look like this:
OLEDB CONNECT TO [Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AdventureWorksDW2012Multidimensional-EE;Data Source=localhost;Location=localhost];
and then your load statement could look like this:
"[Measures].[Internet Extended Amount]" as [Internet Extended Amount],
"[Customer].[Total Children].[Total Children].[MEMBER_CAPTION]" as [Total Children];
[Measures].[Internet Extended Amount]
DIMENSION PROPERTIES PARENT_UNIQUE_NAME,HIERARCHY_UNIQUE_NAME ON COLUMNS , NON EMPTY
FROM [Adventure Works]
If memory serves, when connecting to an OLAP source, you will need to use an MDX query, not an SQL query.
Hi orsh_ so can you tell me if there is a way to do the extraction from the cube? So what driver we need to use?
read my post..