Ciao Mackers...sorry if i disturb you again.

I tested your set but i receive an error that tell that:

i TRANSLATE from italian,...

IT IS EXPECTED A HIERARCHY EXPRESSION INSTEAD YOU DID...

Thanks MACK very kind of you !!!

I test immediately...i read about LEFT VBA FUNCTION but i was not able to understand to use properties Name.

I have to put that set...

Many thanks.

I think it is a good soluton too.

Someone advice me that is it works the same...

IIF(ISEMPTY([Measures].[Sales Amount] )

,NULL

,SUM ({ [Company].[All Company].[COMET]},[Measures].[Sales Amount]) )

,NON_EMPTY_BEHAVIOR = {[Measures].[Sales Amount]}

Thanks a lot.

Sorry but...

CIAO.

Yes it is ...sorry for that !!!!

I hope you apologize me...

Thanks

Ciao

Many thanks to you ..

It works !!!

Thanks again !!!!:-)

Ciao Daniel.

Many thanks i will read as soon as possibile that link.

Regards.

Ciao.

First of all , many thanks for your kind reply.

I understand what you wirtten , so i thank you very much...

Fortunately i discover also a good tutorial of C.Webb about...

Thanks a lot for your kind reply.

Have a good day.

THANKS TO WRITE these very useful articles.

I believe in DAX and PowerPivot , so i ma very happy of that.

Regards.

Okay i understand now

It is displayed WCHAR

Hi .

Do your efer to use properties attribute inside Dimension Designer ???

i did.

I tried to set format attribute as numeric...but nothing happen .when i query that attribute in Excel it...

Hi guys.

Thanks for your kind reply.

Yes i'd like to know how to format a numeric attribute dimension and not format a numeric measure.

Sorry for my english...i created a misunderstanding,,,

I'd like...

I forgot to tell you that , i will inform better about POWERVIEW.

I saw a demo in Milano in march 2012, but it seems a very young product.

And the same...

Ciao.

Many thanks for yoru reply.

Yes Performance Point seems a good solution,

Yes it needs of SHAREPOINT 2010 or next year SHAREPOINT 2013.

It should a good solution, especially for who has OLAP...

Hi many thanks.

I did a lot of test..and i did that.

I WAS ABLE to connect Progress DB in SSIS 2008 r2 using a trial version of PROGRESS DATA DIRECT odbc...