'FROM' - 'TO' - Set analysis

[pamaxeed]

Hi,

i have just a question.

In my usecase scenario i have a calendar with a from date and a to date, which covers a range of dates (Min(startDate), Max(endDate) of my CUSTOMER fact table).

The calendar table is not connected to any other tables in my datamodel

In my application i build two calendar boxes with 'FROM' - 'TO'  data selection.

My question is that i thought i wanna go to use the set analysis to filter my data based on 'FROM' - 'TO'  data selection.

Something like that:

Sum({$<CUST_STARTDATE= {">=$(=vStartDate)}, CUST_ENDDATE= {"<=$(=vEndDate)} >} Value)

My problem is that i not have only charts, but also tableboxes and charts without any real expression like SUM, AVG etc.

How i can accomplish this task without using a function in my expression?

Thanks,

Patric

[lironbaram]

hi patric

i this synthetic keys have bad reputation , more than they should

in this case as you know why the synthetic key was created it ok

the problem is when you have a synthetic key and you didn't planned to have one

[pamaxeed]

Yes i agree, u are right the problem is when u do not know why, for this purpose it could be tolerable ...anyway thank u Liron for ur help, i appreciate it.

Cheers,

Patric