Reporting With Dimensional Data Source TM1 and RS 8.4

[sag4cognos]

Hello All,

I am using Cognos 8.4 and sourcing data from cubes built from TM1 9.5

I got couple of questions. Can any one please suggest me any ideas on these issues.

1. Can we do an expression like - Give the sum of a measure sliced across multiple dimensions.  I am not talking about using an slicer filter in the query. I am thinking more in terms of an
SUM(Measure) For Grouped element - an expression which computes the sum - while working with relational data sources.

2. I am in a scenario, where I have to compute CYTD Actuals, CYTD Budget, CM Actuals and CM Budget ( CYTD - Current Year To Date, CM - Current Month ). I am using two different queries to achieve this. One query is sliced on the member element CYTD and the other query sliced on CM. Can I achieve this using one query ? The issue is I have to make sure the rows are in sync in the presentation layer and sometimes if therez an alignment issue the records go awry. I cannot use a Join Query too, as Cognos throws an error stating "Possible cause is the use of 2-part reference to a model query item"

I am running out of ideas.. The last option for me would be to redo the dimensional model ( I mean the TM1 cube ).. but before I could do that, I wanted to know if I am missing something.

Please enlighten me ..  ???

Thanks,
Sagar