Hi All,

I have a calculated member [date].[Year - Month - Day].[CurrentDay] as
'[Date].[Year - Month - Day].[Day].&[2006]&[10]&[18]'

Use the following query:
select { [Measures].[Count] } on 0
, { ParallelPeriod([Date].[Year - Month - Day].[Month], 1, [Date].[Year -
Month - Day].[CurrentDay])} on 1
from [TestCube]

The result is nothing, no null values or errors. When I change the query
like this:
select { [Measures].[Count] } on 0
, { ParallelPeriod([Date].[Year - Month - Day].[Month], 1, [Date].[Year -
Month - Day].[Day].&[2006]&[10]&[18])} on 1
from [TestCube]

I see result, i.e. the count on 18 september 2006. How is this possible?

Q

I understand [CurrentDay] is another member. It is not the referenced member
itself.

So, I tested as following,

WITH MEMBER [date].[Year - Month - Day].[CurrentDay] as '[Date].[Year -
Month - Day].[Day].&[2006]&[10]&[18].UniqueName'
Select { [Measures].[Count] } on 0
, { ParallelPeriod([Date].[Year - Month - Day].[Month], 1,
StrToMember([Date].[Year - Month - Day].[CurrentDay]))} on 1
from [TestCube]

Ohjoo

"Qbee" <Qbee (AT) discussions (DOT) microsoft.com> wrote

Yes, you are correct.

But I don't see any results. Is it possible to see which date is referenced
on the rows? I know there are some gaps in the data so it can be possible
that it is referencing an empty cell.

Q

"Ohjoo Kwon" wrote:

to be complete:

with member [date].[Year - Month - Day].[CurrentDay] as '[Date].[Year -
Month - Day].[Day].&[2006]&[10]&[18]'

select { [Measures].[Count] } on 0
, { ParallelPeriod([Date].[Year - Month - Day].[Month], 1,
[Date].[Year - Month - Day].[CurrentDay])} on 1
from [TestCube]

No results.


select { [Measures].[Count] } on 0
, { ParallelPeriod([Date].[Year - Month - Day].[Month], 1, [Date].[Year -
Month - Day].[Day].&[2006]&[10]&[18])} on 1
from [TestCube]

Results.

Q

"Qbee" wrote:

I don't know the mechanism of the internal dimension path for calculated
members.

For example, if you test [date].[Year - Month -
Day].CurrentMember.Properties("ID"),
the values are much different between regular members and calculated
members.

It looks like that calculated members do not be considered as normal members
within a hierarchy.
For example, [CurrentDay].Parent.Children does not contain [CurrentDay].

I hope someone has more good information on this.

Ohjoo

"Qbee" <Qbee (AT) discussions (DOT) microsoft.com> wrote