Repost using FOX formula

[Former Member]

Hi All,

I have a Timestamp field in a cube, i would like to repost the data in that characteristic to contain ' ' or '#'' .

Can anyone pls give me suggestions on writing a fox formula to achieve this.

Thanks in advance.

Tarak

[Former Member · Accepted solution]

Hi,

Take it in a field to be changed and aggregation level and then post it with #.Make sure it is not compounded with another characteristic ,if so then handle it.If check for not getting derived through characteristic relatioship.

For example:

data char_fiscper type 0fiscper.

Foreach char_fiscper.

{0amount,#} = {0amount,char_fiscper}.

endfor.

Why you don't want to use standard Repost.

Regards,

Indu

[Former Member]

Hi.

May be you dont need FOX, but use REPOST or COY function.

In FROM selection set # and in TO selection set needed timestamp value.

Regards.