Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by CaptainMo
-
Customer Dimension Modeling
No. Each customer record in CRM only has pipeline data. Each of these CRM customer record is rolled up to the parent, which exist only in the revenue system. I was thinking about creating a cube for revenue and a cube for pipeline, and then a virtual cube using the shared customer dimension.- CaptainMo
- Post #3
- Forum: Data Warehousing/Big Data
-
Customer Dimension Modeling
Here's the assumption: I have 2 systems, revenue and CRM. Let's assume in the revenue system, there's 1 customer record, IBM HQ. All previous billings to IBM are issued using this record. The CRM system tracks only sales pipeline, and has 10 customer record, all IBM subsidiaries whose parent...- CaptainMo
- Thread
- Replies: 4
- Forum: Data Warehousing/Big Data
