robert.gerald.taylor (10/25/2012)

---

Charles,

But my situation is that I have 2008 R2 Standard edition on the production server, but when I open the production SSAS database directly through BIDS/VS I see partitions...

Excel needs unicode data. Insert a data conversion task between your source query and Excel destination, converting all fields to unicode. That should work...

I would start with one fact table at the highest level of granularity (features in your case). It will be easy enough to create a summarized fact table at the...

RenzoSQL (5/30/2012)

---

Hello Fellas,

I have a little question on what would be the best solution for the following scenario I am facing:

I have an ETL job that needs to run every...

eobiki10 (5/29/2012)

---

Hi All,

I have a date field from 01/08/2010 - 06/06/2011. In my report, I want this date to show as 2010 August or 2011 June respectively based on...

CptCrusty1 (5/9/2012)

---

I thought about that, but wasn't sure if that would end up being visible in the report... hadn't got around to trying it yet... Guess I'll have...

Welsh Corgi (4/13/2012)

---

I removed the WHERE Clause that included the input parameter and I still get the error.

When the Task executes the parameter does not have a value.

I did not...

Welsh Corgi (4/13/2012)

---

The variables are set during runtime.

I checked the variables when...

Does your variable have a hard-coded value before execution, or is the value only assigned during execution?

+1 on all Jeff's points above. Most people in this forum would lean towards SQL Server, and for good and valid reasons as Jeff has mentioned.

To give another perspective, you...

PaulB-TheOneAndOnly (3/25/2012)

---

Surrogate Keys add a level of abstraction that isolates and protects...

SQL Padawan (3/13/2012)

---

I was wondering if there was a data management view for data source views. I can not for the life me find anything, anywhere on the web. I've...

FunkyDexter (3/7/2012)

---

OK, so I've been using SSRS and SSIS for a while and decided I ought to learn SSAS. I've spent some time going through a tutorial or two...

Ells (3/7/2012)

---

Kind of

"Any variable that is marked as sensitive. The marking of variables is controlled by Integration Services.

Whether Integration Services considers a property sensitive depends on whether the developer of...

Ells (3/6/2012)

---

Have been looking into this a bit more.

There appears to be two components to the security.

1. The ability to edit the package

2. The security of passwords

I already use config...