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

thank you. This was exactly what I was wondering. I was sure if it was bad practice or not too set up a database with this type of situation possible.

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

ok, these are good ideas. I had forgotten about the hidden fields. The database idea seems good for some situations. In my case, there would be too much writing back and forth to the database on each screen load and with all the other database action that is already happening, I don't think...

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

you know what, I think you guys are right about it. I realized that ASP is server side wheras the javascript events I'm thinking of are client side...so I best to keep them on the client side.

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

ok, that was pretty easy. I did that and it worked when I had hlStart.Style.Add("left", "100px") before it. However, I want to get the position after the page has been all laid out relatively. Is this possible?

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?

ahhh....that is a good idea. Thanks

well, it is because all I really want is a summary section. The database has several values each month. All I want is a summary for each column. ie Shipping costs Summary1 Travel expenses Summary2 Something else Summary3 Eventually, I am going to figure out...

ok, I was able to move the summary to the group header rather then footer and it is working on the right page :) Yea! Now, if I coudl somehow move it into the details section (I am using XI)

ok, I think I didn't quite follow your example the first time. This time, I deleted my group. I also deleted every field (just for testing) except table.value. When I right click on table.value and insert summary, I can select sum but it doesn't exactly allow me to summarize by timestamp...

Ok, well that was interesting. As I said, I'm very new to this. I tried that out as well as using a running total. Unfortunately, the summay block is in the report footer in the design view (it must somehow be moved into the details section and it won't allow me to move it) and it does not...

Ok, here is the SQL. I can't tell what if it is combining the results into one table (which would explain the summation problem) or if it is in two separate tables SELECT "Table1"."TimeStamp", "Table1"."Value" FROM "ADMKRS"."dbo"."Table1" "Table1" SELECT "Table2"."Value" FROM...

I just checked the SQL statement for the report. It is linking the tables. Is it possible to undo this?