473,621 Members | 2,743 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to summerize Calculated Member in SQL2000

I have created a virtual cube in SQL2000. Then, I have generated a
Calculated Member. When I did rollup into a higher level, SQL2000 did
re-calculate the member. However, I want to summerize the Calculated
member. The Solve Order could not be worked in this situation since a
measure, which is used to generate the Calculate Member, will be
available only in the lowerest level of the dimension. Please help me!
Jul 20 '05 #1
1 2183
Anote Sangkunakupt (an******@hotma il.com) writes:
I have created a virtual cube in SQL2000. Then, I have generated a
Calculated Member. When I did rollup into a higher level, SQL2000 did
re-calculate the member. However, I want to summerize the Calculated
member. The Solve Order could not be worked in this situation since a
measure, which is used to generate the Calculate Member, will be
available only in the lowerest level of the dimension. Please help me!


You might get better response in a group like
microsoft.sqlse rver.public.ola p.

--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
3312
by: Scott Brady Drummonds | last post by:
Hi, everyone, I'm still learning Python as I develop a medium-sized project. From my previous experience with C++, I've burnt into my mind the notion of information hiding. I'm having trouble understanding to what extent I should follow this policy in my Python code so I thought I'd ask the group. I read from a previous post that to attain a private-like status of member variables, I should prefix the variable name with two...
1
3337
by: LizP | last post by:
Hi, guys - looking for a bit of help/advice on moving a database from SQL 7 to SQL 2000. We've a third party application which currently uses a SQL7 database. This database has a number of views which are owned by user INFORMATION_SCHEMA and are set as system tables. This user doesn't actually have a login on the SQL server. We've tried the following to recreate the database on SQL2000, but whatever we try, the views owned by...
0
1770
by: Pradeep | last post by:
I wanted to create a calculated member for a cube using member propery os dimension .My MDX syntax is as follows Sum({.})/(Val(..Members.CurrentMember.DataMember.Properties("Int Total Emp"))) Once i browse the data in the cube column gave an #Err. It will be appriciated any one who can show me how this can be corrected Thank You
0
1210
by: Pradeep | last post by:
I have defined a member property called "int Total Emp" under the dimension team and defined calculated member under measures using this property called "total # emp" as .properties("int Total Emp") value expression.But the cell of this calculated member property gicves en erros when rooling up to highr levels . how can i use this member property correctly when adding all the member properties at higher levels Thank You Ruwan
0
1189
by: bk | last post by:
I get "SQL Server is unavailable or does not exist" error while developing asp.net application in vs2003's IDE development mode. The sql2000 is installed on a windows 2003 server. I am able to connect to server using Query Analyzer and Enterprise Manager. My connection string is: string sConStr= "Server = 192.168.0.28;User ID=myuser;Initial Catalog=pubs;Password=mypassword"
2
1682
by: PointMan | last post by:
i make a project in vs2005 that use ASPNETDB.MDF and use <asp:LoginView ID="LoginView1" runat="server" > server control for vs2005 in this case , i'd like to use hosting service but this hosting company does not support sql2005 that's why i have to use sql2000 so my quetion is how can i migration this for sql2000??
13
4433
by: bevanward | last post by:
Hi All I am finding unexpected results when inserted into a newly created table that has a field of datatype int identity (1,1). Basically the order I sort on when inserting into the table is not reflected in the order of the values from the identity field. Have I been wrong in assuming that it should reflect the order from the sort?
0
1717
by: basuritta | last post by:
I am trying to add a SQL2000 subscriptor to a SQL2005 publisher and distributor using the Management Studio. I'm using a non-standard port in both ends, but I have set the port for the TCP/IP protocol to the non-standard port in both the server and client network configuration. I can add the SQL2000 server to the Management Studio console without problems, and even without haveing to specify the port I'm using (as expected)
5
2761
by: happymappy | last post by:
I have a dimension called MyDimension with attributes - Model - ModelValue One of my measures called MyMeasure. I need a calculated measure to calculate the value based on existing measure and dimension Model/ModelValue pair above. In particularly, case
0
8156
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8653
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8597
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8306
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
5554
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4150
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2587
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1763
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1460
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.