Please read the forum etiquette. Posting multiple times and expecting other people to help within the minute is not the way to go.

You probably...

Yeah, I'm following this...

Lidou123 (2/18/2015)

---

Hi, I need to get a MDX query which works like UNION ALL in SQL. It seems to be a bit tricky..

This is what I want in SQL:

SELECT 'Value'...

Rooster (2/18/2015)

---

Hi,

I have a fact table that holds sales values. This is linked to a product dimension. A product can appear in multiple seasons so I want to...

JimbobsQL (2/16/2015)

---

Hi Martin,

Thanks for the reply. That [All] member was put on by Excel as that reference only includes both of the product members in the sub cube.

The calculation I'm...

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