March 2, 2015 at 9:52 am
I'm fairly new to the world of SSAS, but have been around the relational side of data warehousing for a long time -- so apologies if this seems like a newbie question. I'm working with a sales funnel inside SSAS. We basically have a sales process that has 6 distinct processes (each process has its own measure group in SSAS). What I'm trying to do is the following: we have a closing date on step 6 of the sales process. However, I'm not currently populating that closing date at step 1 of the sales process. I want to be able to see how a sale has progressed throughout the entire process.
I want to avoid populating a new column in step 1, if at all possible, because I can see that I would have to do that for every new date that I add to step 6 of the process. I have a common unique identifier in each step of the sales process that I was hoping that I could use to link all of the measure groups together. The question is two-fold: 1) Can I use a common unique identifier to link all of the measure groups together so that I can query dates in one measure group from another measure group? (an if so, how to do that). And, 2) If I can't use a unique identifier to link the measure groups together, is there a more efficient way than adding new dates to step 1 every time I add a new date to step 6?
Any suggestions? Thanks!
March 2, 2015 at 2:45 pm
jjbear11 (3/2/2015)
I'm fairly new to the world of SSAS, but have been around the relational side of data warehousing for a long time -- so apologies if this seems like a newbie question. I'm working with a sales funnel inside SSAS. We basically have a sales process that has 6 distinct processes (each process has its own measure group in SSAS). What I'm trying to do is the following: we have a closing date on step 6 of the sales process. However, I'm not currently populating that closing date at step 1 of the sales process. I want to be able to see how a sale has progressed throughout the entire process.I want to avoid populating a new column in step 1, if at all possible, because I can see that I would have to do that for every new date that I add to step 6 of the process. I have a common unique identifier in each step of the sales process that I was hoping that I could use to link all of the measure groups together. The question is two-fold: 1) Can I use a common unique identifier to link all of the measure groups together so that I can query dates in one measure group from another measure group? (an if so, how to do that). And, 2) If I can't use a unique identifier to link the measure groups together, is there a more efficient way than adding new dates to step 1 every time I add a new date to step 6?
Any suggestions? Thanks!
Can you provide more information? Giving us some test data with test cases and expected outcomes would help us help you.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply