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
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
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
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
Hi khayman,
I give both, ancestor([April 2014],1) and separate member ancestor([Cooking Gear],1).
Same problem will occur.
Thanks & Regards,
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
Hi khayman,
Now it works, Thanks for your golden time to spend me.
Regards,
Chandrasekar