Just to clarify the account that you are coverting and then concatenating what are the datatypes property set for the same.
The reason why it won't work is because Essbase cannot store strings (only and only numbers) Even if you look at how Smartlists/Textlist it is still stored as numbers. Now look at Text measure of Planning the text is kept in planning relational table and Essbase still reports
those as numbers.
There is a custom CDF which splits the string into 8 characters and stores it.
The data type for the account member is Currency and the datatype of the other dimension members which i am concanetating is Unspecified.
I am aware that essbase stores only numeric values. But its in my requirement that i should concatenate the following members ans post it to the particular member. That is y i need to convert it into a integer so that essbase can understand it.
can you please tell me which CDF are you talking about which will solve this issue.
To be Frank i have never tried it.
Lets wait for other people comments in this.
the datatype is not of importance here. First I want to get a clear picture of the problem. You have two members in, let's say, the account dimension. One with the ID "14" and the other with the ID "20".
Now you want to write into the Essbase database into a third member "Year" a value of 2014 ?
I was looking for such an function too. In fact the reverse of @MEMBER what you are looking for.
The closest I did was having such members and storing in some corner of the database the actual value. In my case it was a membername 2000 with the value of 2000 and then the years also with their data value.
Maybe somebody has something better.
Apologies for late reply...i was busy till late. But i got a solution for the problem.
Its just that we need a CDF which can change the string member to numeric. That needs to be registered in essbase.
And that works!!!.
good to see that it works. Getting the CDF to run can be hard sometimes. The correct Java etc.
Maybe post the name of the CDF so others reading this can find it.