Dimwit MDX count problem
i have run small problem. have dimension identifies types of bills. have measure reports how many bills have been issued. there several types of bills. 1 of these adjustment bill. correction existing bill. these represented "a" bills in db
i need count number of unique bills, that's count of bills other "a" bills.
i've looked @ calculated members struggling mdx syntax.
anyone have pointers or articles should read?
it should this:`
with member [measures].[num]
as
'sum(except([bills].[level name].members, [bills].[ ]), [measures].[numbills])'
hope helps,
santi
SQL Server > SQL Server Analysis Services
Comments
Post a Comment