Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Factless tables

Go down

Factless tables Empty Factless tables

Post  Claus The Newbee Wed Feb 06, 2013 12:40 pm

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 ?

Claus The Newbee

Posts : 1
Join date : 2013-02-06

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum