1.

Grouping is an aggregate function that causes an additional column to be output with a value of 1

when the row is added by either the CUBE or...

One question,Have you installed sp3? if not then it gives lots of problem.

Install SP3 patch on your SQL2K server from web.

hth

Hi,

there is syntax mistake in

Avg(Descendants([Time].[2005],[Quarter]),Measures.Sales_Amount).

it should be [Measures].[Sales_Amount]

if you want to avoid nulls and zeros in calculating...

Hi,

I do not think so that SP4 will have any negative impact on SQL2K analysis server.

you can go thru following link before installing.

http://www.microsoft.com/sql/downloads/2000/sp4.asp

hth

Install sp3 from web and then try to register the server.I used to get server registration problem before installing sp3.

hth

 One reason why people use private dimensions is to decrease the reprocessing of cubes. 

If your dimension is fully reprocessed then your cube would lose data and have to be...

Can you give me some details about your number of rows in dimensions tables and fact table? and how many cubes do you have which uses these shared dimensions.

I was...

I tried  pivot tables in Excel which uses cubes in Analysis Services as data source,but i was able to see the values of each measure in excel cell.

My configuration is...

Hi,

Did you browse following links.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/agadvpart_438z.asp

and

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/agadvpart_0rub.asp

Second option is better so that you can see contractor code and corresponding contractor name.

But if you are generating reports then use should always have user friendly things in that case first...

Hi,

I tried the same thing but it got updated.

I am using analysis services from some time but it never showed such a behavior.Dimension or cube gets updated as soon as...

Hi,

we had problem of pulling of large amount of data from source server due to security reason as from the source server only 500 mb data could be pulled.

we resolved our...

Try out following two options

1. Increase tempdb size

2. in Target server connection properties go to advanvced tab,set connect time out to 0.

HTH

one way of doing this in DTS is though DTSrun utility 

1. create a ini file with following tags

[source]

FileName=c:\abc2005_04_10.txt

2. In Dts package create a Activex task with following code.

Function Main()

 Dim gsConfigINIPath

 ...

one way of doing this in DTS is though .ini file

1. create a ini file with following tags

[source]

FileName=c:\abc2005_04_10.txt

2. In Dts package create a Activex task with following code.

Function Main()

 Dim gsConfigINIPath

 ...