Thanks for the reply,

I just realised the method I posted before does not work. In my case, using ObjectExpansion="ObjectProperties" only seems to be working when pointing out one single role...

As per suggestion from Darren Gosbell I changed the way of solving this, to get better performance:

I created a new, hidden attribute where the key is only the second part...

This did the trick:

filter

([Dimension].[AttributeHierarchy].allmembers

,instr([Dimension].[AttributeHierarchy].CurrentMember.MEMBER_VALUE, '592') > 0)

Thanks for your reply Stewart. Will let you know if I try SSIS and fuzzy logic to solve this.

Martin

ptheberge (9/17/2008)

---

I created a SQL Task that does Select count(*) from Table, and then

use the Result Set tab to populate the package variable rowcount.

Put a 0 in the...

Lisset (10/21/2010)

---

Hi everybody, I have the follow description.

Variable

- Name=LoopLimit

- Scope=Package3

- Data Type=Int32

Execute SQL Task

-ResultSet=SingleRow

SQLStatement=select count(*) as Limit from BITACORA_CARGA_ARCHIVO

ResultSet

- Result name=Limit

- Variable Name=User::LoopLimit

When start to debugg, this run without...

Ok I understand. I am a bit surprised that one package per table is the only solution to this using SSIS, but I guess I have to just live with...

Glad to be of help 🙂

sacheen (9/14/2010)

---

Hi Martin,

Your solution worked really well for me... !!!

Thanks a lot for the efforts you took to try this.. 😎

Hey Raunak,

I dropped idea...

Hi sacheen.

I became curious how to solve this also and after some searching the net I just got something working ok. I will try to describe it briefly below:

- After...