TM1 Forum

Looks fine to me too,
we've done it using Aliases as a 'language'.

TM1 isn't going to work well with BI in a true multilingual environment

One thing I would add is that BI sometimes seems to cache things and the changes at cube/framework level don't always instantly come through to Report Studio (although I think for attributes you're ok).



IMHO IBM need to invest quite a lot of time into getting TM1 to play nicely with BI.

Thank you everyone. I do agree that it is a long way before TM1 can replace powerplay as a source for reporting. It is a shame though because TM1's engine is super good.

Grrrr.
Just spent half a day trying to pull attributes through to BI.
Interestingly you can sort on them with the advanced sort thing, but you can't access them via roleValue.
It would be neat to be able to filter YTD,MTD and other niceties via an attribute.

I'll have a look at the XML in the report. There may be something in there that gives a clue as to how I might be able to access an attribute.

ParisHilton wrote:Grrrr.
Just spent half a day trying to pull attributes through to BI.
Interestingly you can sort on them with the advanced sort thing, but you can't access them via roleValue.
It would be neat to be able to filter YTD,MTD and other niceties via an attribute.

I'll have a look at the XML in the report. There may be something in there that gives a clue as to how I might be able to access an attribute.

Please post your findings here, any info on this would be great.

tryinghard wrote:

ParisHilton wrote:Grrrr.
Just spent half a day trying to pull attributes through to BI.
Interestingly you can sort on them with the advanced sort thing, but you can't access them via roleValue.
It would be neat to be able to filter YTD,MTD and other niceties via an attribute.

I'll have a look at the XML in the report. There may be something in there that gives a clue as to how I might be able to access an attribute.

Please post your findings here, any info on this would be great.

From what I can tell, the XML for the report defines the query using standard syntax, but if I look at the generated MDX it is ordering on CurrentMember.Properties("MyCompaniesSortOrder")
so the MDX can be passed to TM1 and can access attribute properties.

Unfortunately I can't simply copy and paste the MDX from the Generated SQL/MDX pane into an MDX Insertable Object. IF I can find out how to do that, presumably I can modify the MDX by hand to filter on attributes instead of sort. (By which time I'd expect IBM to have released a version which exposes attributes ...... )

Has anyone got Tm1 working with cognos 8.3 BI(I can't see a TM1 datasource), because according to the documentation, if you select a query , then in the properties pane, you should be able to click the elipses and see the SQL/MDX, and then convert the generated MDX to something editable.

Unfortunately in 8.4 , it only lets me see the SQL.....

I dont believe that TM1 is available as a data source untill 8.4 and later.

The real performance benefits don't kick in till you get to Cognos 10.1 Fix Pack 1 and TM1 9.5.2

PlanningDev wrote:I dont believe that TM1 is available as a data source untill 8.4 and later.

The real performance benefits don't kick in till you get to Cognos 10.1 Fix Pack 1 and TM1 9.5.2

That would make sense.

Do you have any insights as to why I can't see the generated MDX for a single query in 8.4? I'd really like to get a foothold on handcrafted MDX.