Forum Discussion
OLE DB error
I have been trying to run this measure , however its giving OLE DB memmory issue .I tried some methods but everytime i am getting this issue. method 1 : Measure = CALCULATE( IF ( MAX('...
Hi nemo189 ,
Can you provide some further info please:
-1- An example of the data in each of the tables referenced in your measure.
-2- Number of rows are in each of these tables.
-3- Any relationships that affect these tables and the cardinality (1:1, 1:Many etc.).
Thanks,
Pete
cardinality is 1:many bidrectional . purchase order line(1): purchase details(many).
purchase order line has 4.5million rows, and purchase details has 7.5 million rows.
Running in direct query mode. Its saying needed memory is 1038, limit is 1024.
