Olap design _Card

Hello friends 

  Need Help , i do have a sales BI Application working  . i need to implement the Card Details in my BI Application 

I do have a fact table F1 . that is calculating the sales of the salesman as well date wise. Now i need to implement the Point of sales details also . i need to implement the credit card details also . so that the data can be analysed

Where to implement the Credit card details (credit card Number,Type,Amount, etc details ) should i implement it in a new  Dimension Table  (getting all the credit card Numbers from source table ),  in Fact table (but in this case i dont need any aggregations on Card Basis) or a Fact generated dimension.

Please help /Suggest


July 16th, 2015 2:22am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics