Search results for query: *

I have a calendar dimension and I want to see 2 attributes in my query list: [Calendar].[Date].[Date] [Calendar].[Week No].[Week No] It complains about them not having the same dimensionality. How can I force it to display both in my query output? TIA 'The world isn't round - it's bent!'...

I need to calculate a percentage movement between 2 periods. I'm trying to use the following code: WITH MEMBER [Measures].[Gross Sales Weekly % Movement] AS ({[Calendar].[YMWD].[Week No], [Measures].[Gross Sales]} - { PARALLELPERIOD( [Calendar].[YMWD].[Week No],1,[Calendar].[YMWD].[Week...

I have a calendar dimension in the data warehouse that has (amongst other columns) Date and Week Number. For every record I want to add the week end date to the dimension in the OLAP cube. I assume the parent hierarchy needs to be a hierarchy from the Calendar dimension. Does that hierarchy...

It's been a long time since I used Crystal. I think this is possible to do, but if it is, I can't remember how to do it. I can't use an OLAP report or a cross tab because of the way the data needs to be presented. I have a few descriptive columns, then I need columns for January to December...

Anyone know the syntax and function to get SSIS to populate a derived column with a self incrementing index? I'm using the Derived Column tool but can't find an index or rowcount/rownumber function. Thanks. 'The world isn't round - it's bent!' Spike Milligan

I am incrementally extracting data. I use a variable to store the highest number in an index column and pass it to the Script task. My extraction failed after 900 rows. I am assuming the data did not come into the data warehouse in numerical sequence. How can I check to see what was the variable...

I have used the step by step instructions at http://ssis.wik.is/Data_Sources/Microsoft_Excel/Excel_2007_Step_by_Step to import data from a spreadsheet. However, when I run the package I get an error saying the data in a particular column could be lost, so the extraction stops. The column is...

We are trying to extract data from an Oracle 10g db into SQL Server 2005 via SSIS. Number fields (1/0, null) are losing data when they arrive in the SQL db. 0's come through ok, but any other number ends up as NULL in the SQL db. Strangely, this worked before we upgraded to a 64-bit operating...

I am new to SQL Server 2005. I have a cube that will process in full. But I have created a new partition and get an error message when I try to process it. The message is 'Errors in the high-level relational engine. The binding for the 'XXX' column is not a ColumnBinding type.' The column in...

Sometimes, not always, when I create an email it doesn't get today's date so stays in my Outbox. Does anyone have any idea how to stop this happening? It's driving me crazy. Thanks in advance, 'The world isn't round - it's bent!' Spike Milligan

I have used the detach/attach facilties to enable me to move a database to a different volume on the same server. However, I get an error message. 'Error 9004: an error occurred while processing the log for database {databasename}' This may be linked to a previous error message when copying...

As a part time techie I normally only have to use SELECT or UPDATE commands, but I may need to transfer data from a file to an SQL Server table. I have experimented but can't seem to get it to work. What is the structure of the command to transfer data into an SQL table, starting with the...

I have a database in SQL 2000 that for some reason has duplicated files with different database owners. I need to copy the tables, but just for 1 dbo. Looking at the Export routine I will have to scroll down and tick just the tables I want. As there are over 3000 tables in this application I...

I am having to document some cubes, which is rather laborious. The data is obviously stored somewhere. Does anyone know where the meta data is stored and how to access it? I'd rather just write a few queries than spend ages typing into a spreadsheet. Thanks. Flybridge 'The world isn't round...

I am probably being very stupid here, but I can't see how to create a .cub file. We create the cube in AS and use BO XI for reporting. Becuase of connectivity issues we want to export a .cub file so it can be used locally. Can we create a .cub file in this configuration or do we need a 3rd...

I have a wierd situation on my home PC and I hope someone here can shed some light on it's resolution. I have installed Norton Internet Security 2005. When I log onto the PC under my profile I can't acces my POP email account at ntlworld. The strange part is, if I log onto the PC under my...

Hi Using CR 11. We need to force a column to be present in a cross tab. We have already used info from here to get data present when we query on all data (use left outer join to calendar table) but when we group the data it doesn't work. e.g. we report on products by group. So when we say...

I have a couple of cubes that are giving me the same problem. At the leaf level the users want to see meaningful descriptions. Unfortunately, the source data is not well managed and the same descriptions can be used for different things (!????) Anyway, to get around this, the leaf level is...

I have designed a cube and the lowest level of a dimension is a concatenation of code and description. If I process the cube with just the code as the leaf it runs OK. But if I process the cube with the code + description as the leaf I get an error message complaining about duplicate siblings...

Hi I feel really stupid! I have a new PC and have installed SQL Server and the Sp3a for both SQL 2K and AS, but I don't have any of the Foodmart stuff set up. Is there something else I'm supposed to do? It's been so long since I installed this I can't remember anything else other than the...