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.
“The way I see it, you should live everyday like its your birthday”
TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
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.
“The way I see it, you should live everyday like its your birthday”
TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
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.
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 ...... )
“The way I see it, you should live everyday like its your birthday”
TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
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.....
“The way I see it, you should live everyday like its your birthday”
TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
