dbTalk Databases Forums  

Extra Super Urgent: MS AS 2k + Crystal Analysis 9 + Ragged hierarchies + ParallelPeriod

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Extra Super Urgent: MS AS 2k + Crystal Analysis 9 + Ragged hierarchies + ParallelPeriod in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andrey Savchenko
 
Posts: n/a

Default Extra Super Urgent: MS AS 2k + Crystal Analysis 9 + Ragged hierarchies + ParallelPeriod - 08-29-2003 , 10:14 AM






921540561
Hello, All!

I need urgent help. My project is almost successfully finished. But one
bug is still undecided.

Problem description:

Used technology: MS AS 2k + SP2 as OLAP server, Crystal Analysis 9 as
client.

Cube: Contains several ragged hierarchies dimension and several measures
based on the ParallelPeriod function.

When I browse this cube with excel or MDX sample aplication all works
fine. But if I browse this cube with Crystal Analysis 9 I see only empty
cells.

When I use Data Browser from MS AS Analysis Manager I see in these cells
#Error.

As I understood the problem is MDX Compatibility level. How can I
influence on this parameter (WHERE? on the server or on the client side
and HOW?). Maybe somebody
already solve this problem.

Thanks in advance.

- --
With best regards,
Andrey Savchenko.


Reply With Quote
  #2  
Old   
Rob Anderson
 
Posts: n/a

Default Re: Extra Super Urgent: MS AS 2k + Crystal Analysis 9 + Ragged hierarchies + ParallelPeriod - 08-29-2003 , 10:33 AM






You can set the MDX compatibilty level in the connection string of your
application or on the server in

HKLM\Software\Microsoft\Olap Server\CurrentVersion\MDXCompatibilityValue.

HTH
Rob
"Andrey Savchenko" <a_savchenko (AT) inbox (DOT) ru> wrote

Quote:
921540561
Hello, All!

I need urgent help. My project is almost successfully finished. But one
bug is still undecided.

Problem description:

Used technology: MS AS 2k + SP2 as OLAP server, Crystal Analysis 9 as
client.

Cube: Contains several ragged hierarchies dimension and several measures
based on the ParallelPeriod function.

When I browse this cube with excel or MDX sample aplication all works
fine. But if I browse this cube with Crystal Analysis 9 I see only empty
cells.

When I use Data Browser from MS AS Analysis Manager I see in these cells
#Error.

As I understood the problem is MDX Compatibility level. How can I
influence on this parameter (WHERE? on the server or on the client side
and HOW?). Maybe somebody
already solve this problem.

Thanks in advance.

- --
With best regards,
Andrey Savchenko.




Reply With Quote
  #3  
Old   
Andrey Savchenko
 
Posts: n/a

Default Re: Extra Super Urgent: MS AS 2k + Crystal Analysis 9 + Ragged hierarchies + ParallelPeriod - 08-29-2003 , 10:54 AM



Hello, Rob!
You wrote on Fri, 29 Aug 2003 16:33:02 +0100:

RA> HKLM\Software\Microsoft\Olap
RA> Server\CurrentVersion\MDXCompatibilityValue.

Thank you for response. I know about this option. By default it sets to
1.
That is why MDX Sample application and Excel can work normaly.

But I realy can't understand why cube browser in ms as 2k analysis
manager
and Crystal Analysis can't use it. Maybe there are some tricks for this
or
something like that.

- --
With best regards,
Andrey Savchenko.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.