2 Replies Latest reply on Feb 6, 2019 3:32 AM by Anusha Vasigala

    Published DataSources to write Custom SQL

    Anusha Vasigala

      I have a question on Published Data sources. In my project there is one Published Data source. By using that Published Data source, I want to do a cross join few fields and get the result. How can I achieve Published Data source using cross join.? I heard that by using .mdx files it is possible to do it. Can anyone suggest me how to do this?. My backend is SQL Server.

       

       

       

      I cannot use Custom SQL because the data source is too large and I already have the same in Published Data source.