Search results for query: *

Hi, I have a Reporting Services Report that access a SQL Server 2000 server. I need to select data from a date range, but when I try the code above, I receive this error message: "FORMULA ERROR - CANNOT CONVERT SET TO TUPLE - IN THE {...} FUNCTION". The date dimension structure is...

MDXer, It's kind like this: FactTable <--- Dimension1 ---> Dimension2 <--- Dimension 3 dim_key1 fk dim_key1 pk dim_key2 pk dim_key3 pk dim_key2 fk dim_key1 fk dim_key3 fk I don't know if it's easy to understand, but it's difficult...

Hi, I'd like to know if somebody could tell me how to develop an unbalanced dimension on SQL Server 2005. Thanks, Levodestro.

Good morning, I hava a cube with a distinct count measure. When all partitions have data the measure is shown correctly. However, if I insert a new dimension without data the measure shows wrong data (it duplicates, actually). What could be the problem ? Thanks, Benedito.

Hi, How do I create a virtual cube in SQL Server 2005 ? Thanks, LevoDestro.

Hi, I have a dimension with 4 levels (Year, Quarter, Month, Day). Using OWC 11 I can filter this dimension in anyway, except selecting 4th level in the year 2008. I can filter using all the other levels and even the 4th level of the other years. This problem doesn't occur in Excel 2003...

I found the solution. I'm now checking in wich level of the dimension I'm in to show or not the data.

johnherman, the attributes are indeed related to the Product level. this cube was originally developed in SQL Server 2000 and it works fine. it shows no data in Departament and Sector levels, only in Product level. i checked at Microsoft and i found that this problem was solved with Service...

Hi, I have a dimension with 3 levels: Departament, Sector and Product Code. In this dimension I added some "attribute relatioships" (Product Name, Sale Price, etc). I can process this dimension and the cube with no problems, but when I try to browse the data I get a "#Value!" error message...