Using the dimensional functions in DMR

[will.sl]

I'm not sure if the dimensional functions such as periodsToDate can be used in DMR or Report Studio based DMR. Are there any restrictions for these functions? 

Thanks in advance

[blom0344]

Look here:

http://www.cognoise.com/community/index.php?topic=5529.0

8.3 should be better in this respect..

[will.sl]

I will upgrade to cognos 8.3. And I'm still wondering whether the dimensional functions are working well in FM/RS of cognos BI 8.3. Does anybody have experences on these fuctions and applied them in real project to such as YTD, LastYear task.   

Thanks.

[rockytopmark]

List of function that won't work properly with DMR:

http://support.cognos.com/supported/docs/en/html/cognos8_bi/8.2/rdm_cr_id3217CannotSpecifytheOrderofMembers.html

8.2 document, but I believe still applies

[giovanni.lucarelli]

will


ciao, there is no chance to use dimensional functions in DMR in 8.3. Believe me!!!

U have to upgrade to 8.4... there is a new tag in DIMENSION DEFINITION, named MEMBER SORT in which u can see Sorting Option; u will flag Metadata box and Data box and belowe the Always OLAP Compatible.


ciao