How to use cognos dimensional functions?

[Chandrasekar]

Hi All,

I need the information of how to use cognos dimensional functions and where it placed on member functions?

Please help me?

Thanks & Regards,
Chandrasekar

[Francis aka khayman]

New to dimensional reporting eh? You need to be more specific what issues you are facing.

In the meantime you can read some tips in dimensional reporting here:

http://cognosm.fm3online.com

[Chandrasekar]

Hi khayman,

Ya, I am new to dimensional functions.

I have to add simple ancestor() and Bottoncount() functions.

I create a data item is ancestor([Product Type], 1)  and i get the error message is "Invalid coercion from string to member".

Can you give the suggestions.

Thanks & Regards,
Chandrasekar

[Francis aka khayman]

Lets use Time Dimension as it is more familiar.

The parameter for ancestor function should be a member.
For example, instead of: ancestor([Month],1)
you should: ancestor([April 2014],1)

In your case it should be a specific Product Type member

[Chandrasekar]

Hi khayman,

I give both, ancestor([April 2014],1) and separate member ancestor([Cooking Gear],1).

Same problem will occur.

Thanks & Regards,

[Francis aka khayman]

how did you get [April 2014] ? it should be a member. when you open your dimension, level then there is a folder called members.. inside that folders are the members. members have blue rectangle icon.

If you check the images here:
http://cognosm.fm3online.com/dimensional/dimensional-current-month/

you will see where to find members in your dimension. you should drag them in your query and that is the one you use in the ancestor function

[Chandrasekar]

Hi khayman,

Now it works, Thanks for your golden time to spend me.

Regards,
Chandrasekar