JimbobsQL (2/16/2015)

---

Hi All,

I have a the below query that is being generated by Excel which includes a subcube:

SELECT

NON EMPTY [Channel].[Channel Group - Channel].[Channel Group] ON COLUMNS ,

NON EMPTY Hierarchize({DrilldownLevel({[Product].[Product Number...

butcherking13 (2/13/2015)

---

Would someone be able to point me in the correct direction on how to import data from a Power Pivot workbook to SQL SERVER?

Importing to Power Pivot is simple,...

Lidou123 (2/11/2015)

---

Hi experts!!

I need your help.

I have a Time dimension with a hierarchy.

I have a headache. 🙁

In my Time dimension I have an attribute "Is Working Day France"...

ttdeveloper (2/10/2015)

---

Martin

This definitely helps. So I guess I need to be setting permissions to None to stop all drilling into the details.

I've read some articles on being able to...

ttdeveloper (2/10/2015)

---

Does anyone know if there is an option in SSAS to prevent the "show details" sheet from showing in excel when a user double clicks a specific cell.

Double...

elias.stassinos (2/9/2015)

---

I starting getting random LCK_M_SCH_M locks with huge wait time, which hung my etl proccess.

The ssis package runs like this:

I have 4 containers that run in parallel and do...

brad.mccollum (2/6/2015)

---

I'm working on a project for a client where SSIS handles automated daily imports of numerous Excel / CSV / other files, performs some transactional activities on each of...

jameslauf (2/6/2015)

---

That is what I will do then. I need to study up on Merge and how this will work best for me. This was my first time trying this...

jameslauf (2/5/2015)

---

Hello I am using SSIS 2012 SDT and I am trying to use the Slowly Changing Dimension Transformation. My problem is that I am trying to ETL about 5...

vineet_dubey1975 (2/5/2015)

---

Hi ,

I am having a DimProject with the TypeID , Capacity attributes.

factOut contains measure.OutPutVal.

my Data is something like

ProjectID , TypeID , Capacity

1 ...

KoldCoffee (2/4/2015)

---

OK, hi nevyn, jeff, martin.

Answers:

There are 14 files daily which translates to 14 tables. I will give numbers for the three biggest tables (settings_dimension/keyword/group).

How many rows...

cstg85 (2/4/2015)

---

I typically like to have a separate staging database, because you really don't need a backup of the data...only the ddl of your staging tables are important to...

cstg85 (2/4/2015)

---

Nevyn,

The column names will not change, I will read that Stairways article and give it a shot, thank you for the link. I guess my first thought was to...

My recommendation would be to stage the data on Server 2. It would then be very easy to execute a merge (or insert/update) statement on your target table. You can...

I'll add one more question, if I may 🙂

Are you using the merge component in SSIS (I hope not), or a merge statement in T-SQL?