Cross Join in SAP MDX using Web I
I am facing an issue. I am currently using BO universe on the top of BW infocube. Now whenever i am dragging two dimensions from the universe in my web i report it is creating cross join , however whenever i add any key figures , it changes the cross join to Non Empty Cross Join.
Now while testing the mdx query in MDXTEST i found that while running the MDX query with two dimensions only is giving me a cross join in MDXTEST also, however if i modify the cross join to non empty cross join it gives me the correct data.
Is it possible to do something in BO or SAP side so that my query starts creating non empty cross join rather then mere cross join.
Is it something to do with the transports we run before installing SAP integration kit
Thanks for your support