dbTalk Databases Forums  

Calculated member creation failed in SQL Server 2000 Analysis Services

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


Discuss Calculated member creation failed in SQL Server 2000 Analysis Services in the microsoft.public.sqlserver.olap forum.



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

Default Calculated member creation failed in SQL Server 2000 Analysis Services - 05-18-2006 , 05:44 AM






Hi All,

All the calculated measures are been created from a windows
application using C# on to the analysis services.All the calculated
measures appear in the STRUCTURE PANE but doesnot appear on to the DATA
tab.

(Windows application is basically used to Add/Modify the Leads which in
turn calculates measures and creates on to the analysis services.)

If the prescribed calculated measure is right clicked and Edited and
clicked OK functions properly. This calculated mesure appears on to the
DATA tab now.

But i find it a tedious job to always right click edit and OK.

Is there any alternative for this problem?
Is this a bug?

I get error message like this,

Calculated member "Calculated member Name" creation failed.
An unexpected internal error has occured. Please restart the
application.

we calculate measures like Sum, Count, Avg,median,Top Quartile, Bottom
Quartile.
If required i can provide the MDX queries for all these measures.

Any help on his will be Appreciated.

Thanks
Shankar


Reply With Quote
  #2  
Old   
Tim Dot NoSpam
 
Posts: n/a

Default Re: Calculated member creation failed in SQL Server 2000 Analysis Services - 05-18-2006 , 06:10 AM






Hi Shankar.

Sounds like a property of the measure is missing when it's initially set
through your code. I'm not familar with the AS object model so can't help
much beyond there... Sorry.

-Tim


<reachshankar82 (AT) gmail (DOT) com> wrote

Quote:
Hi All,

All the calculated measures are been created from a windows
application using C# on to the analysis services.All the calculated
measures appear in the STRUCTURE PANE but doesnot appear on to the DATA
tab.

(Windows application is basically used to Add/Modify the Leads which in
turn calculates measures and creates on to the analysis services.)

If the prescribed calculated measure is right clicked and Edited and
clicked OK functions properly. This calculated mesure appears on to the
DATA tab now.

But i find it a tedious job to always right click edit and OK.

Is there any alternative for this problem?
Is this a bug?

I get error message like this,

Calculated member "Calculated member Name" creation failed.
An unexpected internal error has occured. Please restart the
application.

we calculate measures like Sum, Count, Avg,median,Top Quartile, Bottom
Quartile.
If required i can provide the MDX queries for all these measures.

Any help on his will be Appreciated.

Thanks
Shankar




Reply With Quote
  #3  
Old   
shankar
 
Posts: n/a

Default Re: Calculated member creation failed in SQL Server 2000 Analysis Services - 05-19-2006 , 01:03 AM




HI Tim,

First of all thanks for the concern,

Actually there is a property like NON EMPTY BEHAVIOUR in the property
section of the Analysis services which differentiate between the
working measures and non working measures.

Is there anything that has to be done in analysis services, i mean to
set any kind of property.

Is this a bug or error in the code??

Awaiting for your reply.

Thanks
Shankar


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.