Forum Discussion

perezco's avatar
perezco
Icon for Advocate III rankAdvocate III
7 years ago

GetOnly orders with 1 commodity in a multi OLAP_no modelling , can't create any calculated columns

I need to get only orders with 1 commodity in a multi OLAP (no modelling , can't create any calculated columns)   The basic code that I thought:   AS IS /*------------------------------------*/ ...
Need Help
Tips and Tricks
perezco's avatar
perezco
Icon for Advocate III rankAdvocate III
7 years ago

Question - Does exists a limitation to try use TREATAS inside of the filter function?

 

update:  I still not be able resolve this... 

 

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi perezco ,

Apologies for late reply.

You could define an arbitrary shaped filter using the function of TREATAS.  And there is a blog you can learn about it.

If you still can't solve the problem, maybe you could post a dummy file or some sample data and expected output. Then we can help you as soon as possible.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.