Search results for query: *

Here is a hotfix here: http://support.microsoft.com/default.aspx?scid=kb;en-us;814113

This site is a link to a much more helpful forum: http://www.sqlmag.com/forums/messageview.cfm?catid=4&threadid=12288 It seems there will be a fix shortly available.

Here is my new MDX function: (Measures.[Inv Value], ClosingPeriod([Month])) In case anyone was in need of a good solution.

I have done some more testing. The DTS packages that have CSVs with > 37 columns work fine if I do not modify them. If I modify them and click "Define Columns" Enterprise Manager shuts down. Anyone else out there having trouble?

Hello, I have a problem that I don't ever remember encountering before. I have a text file that is comma separated like: 1,2,3,....37,38,39,40 1,2,3,....37,38,39,40 etc. I use a Text File Source connection and point it to the file. I make a Text File Destination connection and point it to a...

Ok, I tried something like this: IIF(IsLeaf([Inv_Time]),sum({[Inv_Time]},[Measures].[Inv Value]),IIF(IsGeneration([Inv_Time],1),sum({[Inv_Time].lastchild},[Measures].[Inv Value]),sum({[Inv_Time].lastchild.lastchild},[Measures].[Inv Value]))) It uses Inv Value instead of Qty, but it is the same...

Scenario: I have the measures Sales and QtyOnhand for items by month. When I view the data for June, I see total sales for the items through June, which is perfect. However, I also see the QtyOnHand is aggregated for all the items (which is great) and for all the months through June (which is...

I have a questions about calculated members. All the examples I see do a simple calculation like GM : [Measures].[Sales] - [Measures].Cost] What I want is inventory value, like: [Measures].[QtyOnHand] * [Measures].[AvgCost] What happens though is that the operations are done in an order that...

I have 4 regions: West, Mid-west, East, and South. I have 3 warehouses in each region. Currently, I have 1 dimension with the levels Region and Warehouse. The problem is that when looking through the data I always have to drill through the region level to look at a warehouse. And when I use...

I have done ASP programming before using ADOand also made extensive use of ADO in Excel and Access. I have also done some T-SQL as well as a good bit of VBScripting using ADO in SQL Packages. So are those really the only ways to go if we develop a program in house (using ADO on web pages, in...

Hello. We are using an ERP system with a poor budgeting module. I am to decide how to best overcome it, but have hit a road block. Background: The ERP system runs a daily routine to updates the data warehouse run on SQL Server. On that same SQL Sever (for now anyway), we plan to have a DB...