Hi there,

I hope that there is someone out there that can help me!

We are busy setting up our cubes on AS 2005 and we have managed to figure
out the Time dimension so that it sorts in a chronological order when connect
to the server. However when we create an offline cube the dates are sorted
alphabetically. I have spent hours on this problem and have now run out of
ideas, is there any one out there who knows what I need to do to have my
dates sorted correctly when offline?

Any help/ suggestion are appreciated.

Thanks,
Nat

Nat wrote:

For Date Attribute set order by property to Key instead of Name.

Regards
Amish Shah

Hi Amish,

Thanks for you note.

However I have already got my Date sorting according to the key, I followed
the step by step instructions as per BOL 2005 - "Sorting Attribute Members
Based on a Secondary Attribute". However as soon as I take my cube off line
it looses the chronological sorting and seems to default back to sorting by
name insteat of Month-NumberofYear.

Any other suggestions or links to where i could figure what i am doing wrong
are very welcome.

Thanks,
Nat

"amish" wrote:

Hi,

After not having any luck with getting any info on any of the newsgroups
regarding this error, i.e. creating off line cube in AS 2005 and the dates
not sorting chronological I decided to log the call with Microsoft and let
one of their engineers have a look at this problem.

After getting feedback, it seems that this is an error with AS 2005 and
Microsoft is planning to have this resolved in SP 2 which they are planning
to release by the end of year. Thus for now that is the only resolution for
this problem, i.e. wait for SP 2.

Thanks,
Nat

"Nat" wrote: