Hi Steve,

Can you tell me what OWC is ? I don't know it and I want to see if the zero supression is affecting me.

I've found the connection string in...

Hi Steve,

I have several dimensions in row and columns. The zero values are suppressed. How can I check which version (SP3...) I have for PTSfull/lite.

This connection string you mentioned...

Thanks Noel and Steve,

Noel:

When I execute the "select @@version" the result is "Microsoft SQL Server 2000 - 8.00.760 ..." so it's not the Enterprise version. Only thing to do is...

Hi Nico,

I think I've seen something simmilar...

I'll see... I'll let you know the result.

Regards,

Bart

Nico,

Varchar should not be a problem.

Which DB are you using (Oracle, SQL server...) ?

How many records are there in each table ?

Has their been any changes in the driver settings...

Hi Nico,

Thanks for the reply.

I thought that I was the only person having

this problem. For now the problem is still not fixed.

What's the data type for the new dimension ?

Regards,

Bart

Hi Steve,

Thanks for your info.

It worked !

Regards,

Bart

What do I have to do when my database/cube

is damaged?

Do I just have to remove the damaged files and copy the backed up files (+ repository *.mdb)to their original place?...

Hi,

How can I backup the repository too ? Can this be done directly from AS or do I have to use MS SQL 2000 to do the job ?

Regards,

Bart

I assume that this T-SQL.

Do you perhaps know how I can input this in

The dimension editor for the field "Member Name Column"

Thanks in advance.

Regards,

Bart

PS Thanks for the very quick reply...

Hi all,

How can I display the month's full name when

I have only a number indicates each month i.e. 1=January, 2=February...

Which formula can I use convert the number to a full...

Steve and Henry,

Thanks for the replies.

Indeed the model is not ye optimized

because it was just for some (quick) testing

to find out what are the limits.

Perhaps we should take...

HenryTr,

I've contacted my DBA the temp. tablespace

is 5,5 GB. I used all... reason the query that AS uses when processing the cube is not good or to sloppy...

Thanks for the...

Shaki,

See the "SQL Server Books Online" it's delivered with Analysis services.

and search (index) for calculated members

quote:

---

No one has responded to this topic...

Thanks Skip,

I think I was a bit to fast with my question.

The books online document gave me also a reason why I got the same data twice.

My fact table is...