Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BobbyPolo

    DTS - Transform Data Task Destination Column Limits??

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

    DTS - Transform Data Task Destination Column Limits??

    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.
  3. BobbyPolo

    MDX Show QtyOnHand based on Time Member selected

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

    DTS - Transform Data Task Destination Column Limits??

    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?
  5. BobbyPolo

    DTS - Transform Data Task Destination Column Limits??

    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...
  6. BobbyPolo

    MDX Show QtyOnHand based on Time Member selected

    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...
  7. BobbyPolo

    MDX Show QtyOnHand based on Time Member selected

    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...
  8. BobbyPolo

    MDX/Calculated Member using Multiplication

    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...
  9. BobbyPolo

    SQL cube - Region and warehouse hierarchy

    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...
  10. BobbyPolo

    Simple, efficient SQL user interface

    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...
  11. BobbyPolo

    Simple, efficient SQL user interface

    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...

Part and Inventory Search

Back
Top