Search results for query: *

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

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

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