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

• Edited by Rakesh Dhar 21 hours 16 minutes ago

Hi Rakesh,

According to your description, you want to implement Credit card details for analysis. Right?

In this scenario, I want to know the structure of your source table for Credit card. If you have a table only has credit card numbers, type, detail, amount, etc, this appears like a dimension table and you can create a new dimension based on a table. If you have a fact table which already relates all users, date and credit numbers including other credit card details, I suggest you create a degenerated dimension based on this fact table. Since some credit card detail information is not numeric, I don't think it's good idea to achieve in a Fact table.

Reference:
Defining a Fact Relationship

Regards,