Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I connected MS OLAP cube and able to get measures and other attributes successfully into Qlik Sense., but my “[Measures].[PatientMaster Count]” is showing as Text. Or not allowing me to create a measure. Is it possible to change my value to Measure?
I am ok to load the data first in QVD and change data while I am re-loading the data in my dashboard.
I tried many things including responses in this thread as well. Nothing is working so far.
http://community.qlik.com/thread/54213
OLEDB CONNECT TO [Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=TestCube;Data Source=400-bdiqs-slq-100;Location=400-bdsql-p-003];
SELECT NON EMPTY { [Measures].[PatientMaster Count], [Measures].[Therapy Count] } ON COLUMNS, NON EMPTY xxxxxxxxxxxxx
Thanks for your help.
This little example should works and result in numeric values (as mentioned in http://community.qlik.com/thread/54213 😞
LOAD *,
num( EVALUATE([Measures].[PatientMaster Count]),'#0') AS PatientMaster Count
SELECT NON EMPTY { [Measures].[PatientMaster Count], [Measures].[Therapy Count] } ON COLUMNS, NON EMPTY xxxxxxxxxxxxx
Also check the data model viewer for that specific field. It should be tagged as $numeric $integer.