Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data modeling problem

I have the tables below created in my load script, I also have a normal standard Master Calendar table.
In the presentation I want to be able to select a Year and Month and then do some calculation e.g Measure_1*NoOfTime. I'm stuck on how this should best be modeled. 

Fact

%keyDateFromTomCustomerMeasure_1Measure_2
11/2/2014_12/31/201411/2/201412/31/2014a10100
10/2/2014_12/31/201410/2/201412/31/2014b20150
NoOfOccurence
YearMonthCustomerNoOfTimes
201410b10
201411b11
201412b11
201411a5
201412a3

Thankful for some hints

1 Solution

Accepted Solutions
morgankejerhag
Partner - Creator III
Partner - Creator III

You can use intervalmatch with extended syntax to connect the two tables. First create a date field of your YearMonth: makedate(YearMonth &  '01','YYYYMMDD')

Then use intervalmatch:

Intervalmatch(YearMonthDate, Customer) load From, Tom, Customer resident Fact;

View solution in original post

2 Replies
morgankejerhag
Partner - Creator III
Partner - Creator III

You can use intervalmatch with extended syntax to connect the two tables. First create a date field of your YearMonth: makedate(YearMonth &  '01','YYYYMMDD')

Then use intervalmatch:

Intervalmatch(YearMonthDate, Customer) load From, Tom, Customer resident Fact;

Not applicable
Author

Thanks :