master calender based on 2 dates in fact table

[userid128223]

Attach I have qvw that has inline table containing 2 different dates.

1. I want to create one master calander with combination of both dates.
2. Master Calander should have connection with inline table so that when i create month, Year selector, I can show corresponding data.

I have dealt with creating master calander from one date, however creating from 2 dates is confusing me.

is it possible to this via set analysis or script. please help

[userid128223]

Any help with this anyone.

[kaushiknsolanki]

Hi

   Please find the solution in attachment.

   Hope this is what you want.

Regards,

Kaushik Solanki

[userid128223]

Thanks Kausik

your solution dont work as 2 tables are not linked.

I was thinking of just concatinating 2 dates would that work.

[userid128223]

what i want is something like this

• one master calander that has all the dates from both date field which will link.
• i also wanted to have some kind of flag for where to be able to called 1 date field vs other if required.  or both.

[kaushiknsolanki]

HI,

   I am Sorry but the requirement is still not clear to me.

   Will you please elaborate with an example.

Regards,

Kaushik Solanki

[userid128223]

Date-1   Date-2  ID

1) Date 1 + Date 2 (all dates combined) into a calander Day, year, month field. Which is linked to table and will show data as per dates selected. it will show match from both Date1 and Date2.

2) 3 flags created

     1) Date 1 only found

      2) Date 2 only found

      3) Both found.

[#8]

Hi amiumi66,

I have the same problme as you.

Have you found any solution for that?

Regards,

Ivelin