Dear SQL TEAM,
I would like to ask you how is it possible to
filter the data in OLAP, with the below examples
it's work but only if I select actual data it
means if the date exsist in the database (in
our case: 2001.March.8 and 2001.March.20 it's
work:
1) RETURN TRUE (WORKING)
SELECT {( [Measures].[Or Total] )} ON COLUMNS,
{( [YearMonthDay].[Year].[2001].[March].[8] :
[YearMonthDay].[Year].[2001].[March].[20] )} ON ROWS
FROM Customers
But if I try with the date who is not existing
in the database (it's not actual record) it's
appearing "CANNOT BIND UNKNOW MEMBER"? , is
it possible to make between without any constraints
if the data with the specificed date is in
the database or not?
Please give me any any advise , Todor
I would like to ask you how is it possible to
filter the data in OLAP, with the below examples
it's work but only if I select actual data it
means if the date exsist in the database (in
our case: 2001.March.8 and 2001.March.20 it's
work:
1) RETURN TRUE (WORKING)
SELECT {( [Measures].[Or Total] )} ON COLUMNS,
{( [YearMonthDay].[Year].[2001].[March].[8] :
[YearMonthDay].[Year].[2001].[March].[20] )} ON ROWS
FROM Customers
But if I try with the date who is not existing
in the database (it's not actual record) it's
appearing "CANNOT BIND UNKNOW MEMBER"? , is
it possible to make between without any constraints
if the data with the specificed date is in
the database or not?
Please give me any any advise , Todor