Skip to main content
Solved

Using conditions in the GI relations table

  • 9 February 2024
  • 3 replies
  • 127 views

Forum|alt.badge.img

I attended a fascinating summit session given by Steve Hoglum in which he discussed how to optimize GIs by applying conditions in the GI relations table, if I am remembering correctly. I downloaded the presentation PDF but I couldn’t find what I was looking for.

Again, if I remember correctly, he suggested adding conditions in the relations table, something like this:

Did I remember correctly? If so what is the format for dates?

Best answer by frederickodendaal77

@michael73 That’s correct, it will only pull data based on the date you select for your parameter. The parameter just replaces the date you wanted to hardcode

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img

Hi @michael73 , you remembered correctly. What would be even easier is to use a parameter for the date. So you could do something like this:

 

But it is important that your join is an inner join. So you might want to do this relation on the customer join like so because that can be an inner join:

 

 

Here is the parameter:

 

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 49 replies
  • February 9, 2024

So the Parameter achieves the same thing as doing it at the relation level? In other words it will not get ALL the data then apply conditions but will rather get data that is within parameters like a where clause in SQL?


Forum|alt.badge.img

@michael73 That’s correct, it will only pull data based on the date you select for your parameter. The parameter just replaces the date you wanted to hardcode


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings