Factless tables
Page 1 of 1
Factless tables
I have a factless table
DimOwner(Ownerkey,CorporateNo,CorporateName,CustomerNo,CustomerName,InstallationNo)
DimDate (DateKey,Day,Month,Year)
FactlessContractCoverage(OwnerKey, DateKey)
Every entry in FactlessContractCoverage tell me that there is a contract for that installation for that month (every entry in registrered the first of the month)
I need to calculate percentage count(Ownerkey)/count(installation) * periodinmonth ; per customer ;per corporate is the possiple?
Ex.
customer no : 50050 has 139 installations period of time 72 month
total coverage : 139 * 72
actault 60
percentage for customer 60/139*72
how do a write MDX for this ?
DimOwner(Ownerkey,CorporateNo,CorporateName,CustomerNo,CustomerName,InstallationNo)
DimDate (DateKey,Day,Month,Year)
FactlessContractCoverage(OwnerKey, DateKey)
Every entry in FactlessContractCoverage tell me that there is a contract for that installation for that month (every entry in registrered the first of the month)
I need to calculate percentage count(Ownerkey)/count(installation) * periodinmonth ; per customer ;per corporate is the possiple?
Ex.
customer no : 50050 has 139 installations period of time 72 month
total coverage : 139 * 72
actault 60
percentage for customer 60/139*72
how do a write MDX for this ?
Claus The Newbee- Posts : 1
Join date : 2013-02-06
Similar topics
» Regarding Factless Fact Tables
» Difference between Aggregate Fact Tables, Rollup Tables and OLAP Cubes ?
» Factless fact tables and SCD2
» Multiple Fact tables, Aggregate tables or a different approach
» Impact of type 2 dimensions on factless tables
» Difference between Aggregate Fact Tables, Rollup Tables and OLAP Cubes ?
» Factless fact tables and SCD2
» Multiple Fact tables, Aggregate tables or a different approach
» Impact of type 2 dimensions on factless tables
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum