To show all dates in chart

[agni_gold]

Hi All ,

I have a situation

I have 2 Fact tables and one calender

Now my both facts are linked with each other by 2 concatinated fields (Field1 + Date)

and one fact is linked with calender by his date field.

Now when i am making staight table with dimension as Month and Day and  2 expresions are sum of Amount from 1st fact and sum of amount of 2nd Fact.

Then it is only showing common day which is common in both fact .

But i want all the days in a month , for those value is not present it will show 0 and rest values.

[agni_gold]

My application will be sort based on entity only , and days should not filter when i select entity , suppose in my calender 15 days are present then in my chart days  will not filter.

this is my basic requirement

[#3]

This is what you can use

Fact1:
LOAD Date1 AS Date,
Entity1,
Date1&Entity1   AS Link,
Amount1
FROM

(ooxml, embedded labels, table is Fact1);

outer join
LOAD
Date2 as Date,
Entity2,
Date2&Entity2   AS Link,
Amount2
FROM

(ooxml, embedded labels, table is Fact2);

Calender:
LOAD Month,
Day,
Date
FROM

(ooxml, embedded labels, table is Calender);

[agni_gold]

same case heappen , when i select entity1 it will sort the days.

[#5]

Use this and then you can use Flag to distinguish from where your entity is coming:

Fact1:
LOAD Date1 AS Date,
Entity1 as Entity,
Amount1,
'Fact1' as Flag
FROM

(ooxml, embedded labels, table is Fact1);

outer join
LOAD
Date2 as Date,
Entity2 as Entity,
Amount2,
'Fact2' as Flag
FROM

(ooxml, embedded labels, table is Fact2);

Calender:
LOAD Month,
Day,
Date
FROM

(ooxml, embedded labels, table is Calender);

[#6]

You can as well say concatenate in place of outer join both will work