To add to my previous response:

If you want to create an "OR" scenario and display both members separately, include the "All" member from each attribute hierarchy:

with set [Filtered Customers]

as

{

{strtoset('{[Retail Customer].[Gender].&[Male],[Retail...

To create a named set, the syntax will look something like the following:

with set [Filtered Customers]

as

{

{[Retail Customer].[Gender].&[Male]}

* {[Retail Customer].[Marital Status].&[Divorced]}

}

select{[Measures].[Units Sold]} on 0

,{[Filtered Customers]} on 1

from[Sales]

The above will create a...

Yes, you cannot use the same hierarchy in the where-clause and the "Rows" axis.

You have 2 options in this case:

1. Instead of using it in the where-clause, create a...

jjbear11 (3/2/2015)

---

I'm fairly new to the world of SSAS, but have been around the relational side of data warehousing for a long time -- so apologies if this seems like...

brad.mccollum (3/2/2015)

---

I've done some extensive work over the past year with SSIS for a client, developing a comprehensive series of packages to do ETL and perform other tasks on numerous...

Yes, that is correct. A bit of a training issue, but that is not unusual.

It would also be possible to use Scope Assignments to "lookup" the measures through the BU...

Yes, it can be done. Use the StrToSet() function in your where clause to filter, with the values of your dropdown...you may have to format these a little.

I would personally recommend the following:

* Keep separate Business Unit and Product dimensions. You really don't have any other choice because of your fact tables.

* Either have the Business Unit...

MaggieW (2/26/2015)

---

Dear all:

I need to write a Stored Procedure or SSIS package to export only new records with a time stamp from a table in SSMS to client's desktop.

How should...

paul.smith2 (2/27/2015)

---

HI folks,

I need some help desperately. I am very new to report builder 3.0 and have never written in SQL and dont really understand it. I am however comfortable...

mannychohan (2/26/2015)

---

I need to extract records from the table which have not been processed. Based on the resultset I receive, I will need to query different tables to extract record...

mannychohan (2/25/2015)

---

Hey Guys, I needed assistance with exporting Data to Flatfile.

I have placed following controls into package.

DataFlowTask --> Exports data into a tab delimited flat file. Column...

The "ALL" member usually comes to...

Lidou123 (2/25/2015)

---

Thank you Sir.

I tried this and that's work well.

But I dont't know why my [ALL MEMBER] is null.

Do you know I can rename it like ' All Clients'...

Lidou123 (2/25/2015)

---

Re All,

I tried this

SELECT NON EMPTY {[Measures].[MyMeasure]} ON COLUMNS,

NON EMPTY {

Hierarchize (

Generate (

...