Hi Guys ,
Usually the simplest thing that most of cognos developers know is Tuple will give you a exact cell in a crross tab .Like we have Year as rows ,product line as column and revenue as measure
So by tuple we can get tuple ([Revenue],[2004],[Camping Equipment])
So while working with crosstab and charts in which scenarios can we use tuple is the first thing to consider.And why we decided to go tuple in those cases
IBM defination
The tuple function serves to specify the specific context that a filter, sort order or another function (such as value() or rank()) will operate against. A tuple indicates which coordinates of the cube are in use for the operation being executed.
where to use Tuple
In the example we are getting the revenue for 2005 because time is showing values for 2005.So as
long as we have the dimensional value in crosstab we do not require to go for tuple.Consider we
did not have 2005 in the crosstab and we wanted to work on 2005 revenue .then we go for tuple.
One more thing to keep in mind is we are not specifying both the dimensions required for tuple
only one dimension.The other dimension it will take from current dimension.In this case the
product line.
Note Every hierarchy has a default member or default measure in case of measures.The default member in case of [great_outdoors_company].[Years].[Years] is YEAR which means it will have all the years data consider the year hierarchy has 4 years 2004,2005,2006,2007 then Year means all the members .So in case of complete tuple when we say default member in case of year it will be all years.
Few Useful notes
when we go for set ?
In a crosstab we need to show months as columns say Jan ,Feb march .We just drag the month from teh model and it has jan,feb march as members so it workds fine.
Suppose you want to define a new column which has Year 2004,Quarter1 2004,Jan,Feb,March you put all of these members into one set .So you now have one new column which has all the members that you want and without set you would have to put these members manually as columns .
Usually the simplest thing that most of cognos developers know is Tuple will give you a exact cell in a crross tab .Like we have Year as rows ,product line as column and revenue as measure
So by tuple we can get tuple ([Revenue],[2004],[Camping Equipment])
So while working with crosstab and charts in which scenarios can we use tuple is the first thing to consider.And why we decided to go tuple in those cases
IBM defination
The tuple function serves to specify the specific context that a filter, sort order or another function (such as value() or rank()) will operate against. A tuple indicates which coordinates of the cube are in use for the operation being executed.
where to use Tuple
In the example we are getting the revenue for 2005 because time is showing values for 2005.So as
long as we have the dimensional value in crosstab we do not require to go for tuple.Consider we
did not have 2005 in the crosstab and we wanted to work on 2005 revenue .then we go for tuple.
One more thing to keep in mind is we are not specifying both the dimensions required for tuple
only one dimension.The other dimension it will take from current dimension.In this case the
product line.
Note Every hierarchy has a default member or default measure in case of measures.The default member in case of [great_outdoors_company].[Years].[Years] is YEAR which means it will have all the years data consider the year hierarchy has 4 years 2004,2005,2006,2007 then Year means all the members .So in case of complete tuple when we say default member in case of year it will be all years.
Few Useful notes
when we go for set ?
In a crosstab we need to show months as columns say Jan ,Feb march .We just drag the month from teh model and it has jan,feb march as members so it workds fine.
Suppose you want to define a new column which has Year 2004,Quarter1 2004,Jan,Feb,March you put all of these members into one set .So you now have one new column which has all the members that you want and without set you would have to put these members manually as columns .
Greetings,
ReplyDeleteIf we get a situation to use set inside a tuple, if there any alternative way to get the result Since tuple doesnt allow level or set inside it? or do we need to go for other function than tuple ?
Sathish