Hi all,
Can i use relation date functions in tuple function, i am getting below error
XQE-PLN-0264
The argument at position 12 of the function 'tuple' is invalid in data item 'Data Item13' of query 'Query2', expected one of the following types: 'member, measure'.
Thanks,
Karthee
Quote from: karthik12345 on 09 Mar 2016 07:27:42 AM
Hi all,
Can i use relation date functions in tuple function, i am getting below error
XQE-PLN-0264
The argument at position 12 of the function 'tuple' is invalid in data item 'Data Item13' of query 'Query2', expected one of the following types: 'member, measure'.
Thanks,
Karthee
Hi,
Tuple functions are designed to operate with members and measures - ie in an OLAP or dimensional package. Relational date functions are designed to work with dates in a relational database - ie a relational package. Can you explain what you are trying to do?
MF.
Thanks MFGF,
I am trying to get current and last month data(dynamically),for that i used date functions in tuple function.
Thanks.
Karthee
A well-designed dimensional source would have relative time already defined for the report author. Are you sure your source doesn't have this? What type of dimensional source do you have (PowerCube? DMR?).
If you don't have any relative time defined then you will need to construct a MUN. You will need to understand what your date MUN looks like. I would suggest you do a search for something like "cognos mun current date" to learn more. Below is one link that might help you. Of course the MUN format in this post won't be the same as yours but you should be able to adapt the concepts to your own MUN.
http://www.cognoise.com/index.php?topic=17475.0