mleznik
11-24-2003, 10:09 AM
Count function is not taking in account any conditions - if i do a query like:
with member [Measures].[Count] as 'Count([Something].Children, ExcludeEmpty)'
select {[Measures].[Count]} on Columns,
{[Dim].[Val1], [Dim].[Val2]} on Rows
from [My Cube]
it will return full count of [Something].Children for both rows rather then returning only those with the proper Val1 and Val2 [Dim] values
Is it a cnown bug and is there a workaround for now?
Thanks
with member [Measures].[Count] as 'Count([Something].Children, ExcludeEmpty)'
select {[Measures].[Count]} on Columns,
{[Dim].[Val1], [Dim].[Val2]} on Rows
from [My Cube]
it will return full count of [Something].Children for both rows rather then returning only those with the proper Val1 and Val2 [Dim] values
Is it a cnown bug and is there a workaround for now?
Thanks