Elliot Rapp (11/18/2011)

---

Thanks!

My hope was to set the datatype just before the cube. My initial hope was to use a calculated value in the measure to convert the string...

This makes the solution:

upgrade from office 2003 to office 2007/2010.

We're almost 2012, your current...

Or a lot of A0 pages......

cengland0 (11/18/2011)

---

Okay, so I knew it rounds the milliseconds to .000, .003, or .007; however, I didn't know when it rounds up or down.

So, when the time ends in .001,...

ChrisM@Work (11/15/2011)

---

Lowell (11/15/2011)

---

I have a coworker who heats up things in the microwave.

(He or She) clicks the Instant 30 seconds button, waits 10 seconds, watching the count down, and then...

Vacation jobs:

* finance department of a hospital

* various jobs at different warehouses. Most of the time doing heavy lifting.

* very shortly calling people to take surveys. Annoying job, lying to...

Some dummy instructions: 🙂

in the editor of your flat file source you need to configure the error output.

For the column col10, put the error configuration to "Redirect row" for truncation.

This...

I think Excel can handle only 256 columns.

In my opinion, a report with more than 10 columns is not user-friendly anymore.

If you have more, you are just creating data dumps....

I must say they really put an effort in forum spam these days.

So much text...

You'll need to put some ETL in place to convert the measures to the corresponding data type.

Furthermore, normally a measure isn't a string. Strings mean it is some sort of...

Read your Excel file like you normally do, and then use SQL to read from the SSAS cube.

This is possible, according to the following article:

http://cwebbbi.wordpress.com/2006/06/14/can-i-run-sql-against-an-analysis-services-cube/

However I'm not sure you can...

weisietan (11/18/2011)

---

I try using the sql server 2000 to retrieve date using Between

the first data will counted but the last will not counted.

Example:

Name between 'A%' and 'C%'

just will get the...

Nice question. This one should have been 2 points and the one of yesterday only 1 point.

Ah well 🙂

The difference between the SQL and the MDX is that in your first query, you join also against PackageSales. However, you don't need this table to get your result. The...

Yesterday I gently ticked someone on the fingers for cross posting.

I got a private message of him apologizing and he explained me that he had now read the forum etiquette...