Hi,

I experienced this problem in another diagram and could solve it by converting the parameter to a string first and then to a number. Of course this is crazy,...

Hi,

it works. You just have to use seperate Attributes for your hierarchy paths. Make sure that your keys are unique like this

year: 2007,2008 ...

month: 200701, 200702...200801 instead of...

I do not use perspectives.

I am not able to query the attribute via mdx.

Stefan

Hi Steve,

as I told I have SP4 on the Analysis Services. I know that they have different installation routines under SQL 2000. 😉

The problem with the AS is...

Hi Steve,

this would solve the problem if I only would need to connect users to SSAS and simply giving them the rights to access the cubes. But I have...

Hi Steve,

I have some very large Dimensions (400.000 Elements). After processing them I regularly do a restart of the OLAP Server, because of the memory leak. But I do...

Hi,

thanks for the reply. But the permissions could not be the problem, because I did this with the same credentials and the same settings thousands of times. And nothing...

Hi,

I had the same error when using one Microsoft Data Link für two parallel running processes in one dts package. The connection was blocked and this caused the package...

Hi,

about Tools: I made good experiences with Enterprise Architect from Sparx Systems . It is a software modelling tool. http://www.sparxsystems.com.au/

You can import DDL Schemas by using OLEDB and ODBC connections...

Hi,

the article is good but I missed the usage of the new possibilities of SQL Server 2005 SSIS. In SQL 2000 it was a common way to use a...