Search results for query: *

Hello, I am new to analysis services but an very impressed with how easy it is to set up star structures, etc. It looks to me like SQL server 2000 and Analysis Services are like two separate servers. I was hoping I could create a star dimensional model database using Analysis Services and...

I am writting a DTS to transfer data from flat tables and spread it into multiple tables in a star schema from. I am planning on using an ActiveX Script Task to preform the operation. The operation, however, is involved and tedius since so many things must be accounted for. Is ActiveX Script...

I'm writting a fairly complex DTS that takes data from one place and spreads it out to a bunch of other places. It is basically just one activeX script task. The problem is that I can only debug by placing message boxes in various locations and seeing if the script executes to that point. No...

Hi, I am just starting learning about the star model and am wondering if a dimension table can contain only one attribute. For example, check out the tables below FACT_TABLE StreamTypeID (foreign Key) Value DIM_STREAM_TYPE StreamTypeID (key) StreamType The DIM_STREAM_TYPE table really only...

Can dimension tables contain NULL values? This comes up if we have a FACT table that contains a time dimension. Suppose the time dimension table has attributes Year, Month, Day. The fact table contains all kindas of transactions. Suppose there is a transaction that occurs at a yearly level...

Hello everyone, I was just wondering if there is some way to pass a variable between reloads of a webpage. I thought of one way to do it would be to have invisible text boxes and then just change the value within them. An alternative could be to add the variable to the URL but then it is...

Hello, I would like to handle an onmouseover event with something like Private Sub Temp(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Panel1.MouseOver 'stuff End Sub Unfortunately, this event is not available. With javascript...

Hi, I am trying to get the position of a control in a webpage during the page_load sub routine. Any ideas of how to do this?

I have been trying to get the position of a control by using hlStart.Style.Item("left") in the page_load procedure but it is not working. Is there another way to get the position?

Hello, I am very new to crystal reports. I'm trying to make a formula that sums by month. This is what I have sum({table.Value},{table.TimeStamp}, "monthly") The problem is that it is not summing correctly. Here is the data I am using 5/15/2004 4:30:00 AM 44190 6/20/2004 4:30:00 AM 40100...

Hello, I cannot figure out how to set the column width for a table no matter how hard I try. I've used this code but it doesn't do anything Table.Rows(0).Cells(0).Style.Add("Height","150px") I've also tried Table.Rows(0).Cells(0).Width = New Unit(150,UnitType.Pixel)

I have some code that looks like there is a memory leak (ie...in C++, there would be a memory leak since I didn't release the memory when I created the second instance of mycommand). The code is below Dim myCommand As New SqlCommand(myDropTable, Conn) Try...

Hello, I have found an 'easy' tutorial for setting up web templates (http://www.devarticles.com/c/a/ASP.NET/Easy-ASP.NET-Page-Templates/1/) but cannot get it to work. Any ideas? Here is my code. I think the mistake is some obvious little thing...

Hello everyone, I am creating a website using Visual Studio .NET. Is there any special way to create a template? My current method is to include a header and a footer file in each html page generated by Visual Studio. Is there a better way of creating a template?

I want to initialize the size of certain components on my webpage when the browser changes size. Is this possible?

Hello, I am trying to use a tabstrip control but I am having a problem with events. I've added the tabstrip, and double clicking on it creates the subroutine Private Sub TabStrip_SelectedIndexChange(ByVal sender As System.Object, ByVal e As System.EventArgs) However, whenever I change the...

I created another dialog which I want to pop up when I hit the a certain menu button. It does not work however. The help one does pop up though and the code seems almost identical. this is the code which makes the help dialog pop up. The second dialog I made is called History and has it's...

Hi, I have a problem with a simple program I am trying to write. It is a calculator. All the operations work fine but I want the numbers keys on the keyboard to be short cuts to the keypad of the calculator. I want pressing "1" on the keyboard to have the same effect as clicking...