Forum Discussion

johnsmith92's avatar
johnsmith92
Regular Visitor
4 years ago
Solved

Translate SQL WHERE clauses to a query

Hi all! I have a very simple model with 2 tables - one fact with cases and history and one date dimension in SSAS. I need a measure to count open cases at the start of each contextualized period. So ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    johnsmith92 , if you do not have an active join between two tables then you do not need a crossfilter. Make both join inactive

johnsmith92's avatar
johnsmith92
Regular Visitor
4 years ago

Hi amitchandak. Thanks for your prompt reply! Unfortunately we are running SQL Server 2014, so I cannot use the CROSSFILTER function. Is there another way to write it?

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    johnsmith92 , if you do not have an active join between two tables then you do not need a crossfilter. Make both join inactive

    • johnsmith92's avatar
      johnsmith92
      Regular Visitor
      4 years ago

      I did as you suggested, but now I'm getting some wild results that are not expected.

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        4 years ago

        Hi  johnsmith92 ,

         

        Is your issue solved now?

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my reply as a solution!