You saved me! Thank you again! :-):-):-)

Hello everyone and thank you for the Answers!

Phil your solution is great!!! Thats exacrly what I need! Quick and clear!

Thank you very very much!

Hello!

After changing the Original Oracle Database and setting NLS_NCHAR_CHARACTERSET = UTF8 it works in the production Database too! Uff!

Thank God! I hope it helps someone, someday! :hehe:

Regards,

Rena

Thanks!! 🙂 I never give up before I solve the Problem. ;-):cool::hehe:

FYI!

It was a pain to create a Database in Oracle... I have not the logic Database = User = Schema... I don’t get it even now... and I am confused...

Hello Ed Wagner and really thanks for any help!

The problem is that i am using the sql server 2012 Attunity service and i cant do any select on the source...

Hello and for your info,

it works when the source column type on the Oracle Database is nvarchar2 and i get the right data on the SQL Server Tables...

As an Oracle...

Hello again and thank you really for your help!

Here 2 examples:

Source Type, Source Value, Destination Type , Destination Value

Varchar2, '164f3293-e5fa-435e-a15d-f67ab12b1486', nvarchar, ‘??????????????????’

Varchar2, '164f3293-e5fa-435e-a15d-f67ab12b1486', varchar, ‘??????????????????’

Great!!!

Here the results after I...

Thats great that you have experience so you can help me!! Hm the problem is that i always use nvarchar on the sql server. And the sql server knows that...

Using the etl tools for many years, that was the first thing that i checked. The source column type is varchar2 and the destination is varchar...

Hello everyone!

I did that :

I created two new Measures:

Measure : CountFinalStockDays with AggregateFunction : Count

Measure : SumFinalStockDays with AggregateFunction : Sum

New Calculate Measure : [FinalStockDays] --> MDX :

'[Measures].[SumFinalStockDays]/[Measures].[CountFinalStockDays]'

And it...

Hello again...

I have a different problem now... I could not calculate the moving avarage with an MDX Query so I tried it with sql. It works but I realy know...

Ok,

I will try it again. Thanks for your Help.

Thank you again. I dont know if I am wrong but I use it on the cube. I create the Calculate Member with this syntax...

The same error using this. I really dont understand. 🙁 :doze:-->

'Avg(

{[Time].[Month].CurrentMember.Lag(1):[Time].[Month].CurrentMember},

[Measures].[Period Demand])'