TM1 Forum

Anybody, any knowledge on this?

I have taken ownership and even then this problem persists.

Hello,

The sandbox is disabled in a TM1 contributor applications that I have created. It is enabled in TM1 Web and perspective. Even in the design mode of TM1 Contributor, the property "Enable Multiple Sandboxing" is said to Yes. Any clue what else I could be missing?

Thank you JIm, so in this cube do you have any rules/feedres at all or is it just loaded through TI processes?

Also, have you ever worked with powerplay, if yes then how would you compare the performance?

Guys,

I have a DB that has over 30 million cells, I am planning to load that in TM1 for reporting. Has anyone dealt with such large number of records. How will be the performance, assume we can get 64 GB Ram on the server and have about 15-20 users accessing data.

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 repor...

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.

Martin Ryan wrote:
['Level'] = S: trim(str(ELLEV('plan_business_unit', !plan_business_unit), 3, 0));

Thank you Martin, that worked like a charm. I do have one question though, why does it need this in the attributes cube but not in regular cubes?

So you don't get to see any attributes of any kind in Analysis studio. Whichever alias you pick in FM is what becomes the element description that is shown to you. These are the steps I am following: 1. Run Metadata wizard 2. Select the datasource and cube 3. In the window Metadata Wizard - Select ...

I have found that even with numeric attributes you have to use the S: syntax. I think this is because the element type (as in what is returned by the dtype function) is "AN" not "N". Martin When I create this formula below it gives a syntax error. I tried this formula with a str...

Yes you can see an alias but you pick it when importing the cube into the framework model. Other attributes are not available in analysis studio to filter on. When I import the cube in and FM model I do get an option to click on an alias, but the moment I open up the cube in analysis studio I am un...

It is a numeric attribute.

I have seen that issue with BI in the past as it doesnt like ragged hierarchies. Try the following test: b) Manually 1st add all the codes you want to see eventhrough they are at different levels (You can use a attribute rule at a later stage) These should filter through to Report Studio but from p...

Are you able to atleast see the alias in Analysis Studio, or just the original name. If you cannot see any alias then the whole point of using TM1 as a reporting source is pointless because a cube is best used for analytical reporting and most of the times the dimension item names would be numbers r...

Herman, Thanks for the response. I thought that an attribute might solve the problem, but then I might have to create an attribute for every level in the hierarchy, also every time I add an item in the hierarchy, the attributes cube will have to be updated? Also, any clue on how to fix Analysis Stud...

Thank you planning dev and apologies for such a delayed response. The solution worked in the report studio; however, I faced a problem there. If there are 3 levels in a hierarchy i.e. level 0(lowest), level 1 and level 2. The hierachy is uneven i.e. few members in level 1 have members under it in le...

Thanks...

My bad. I googled it and did not find anything. Thanks for the link. One question though, what do I now do to install architect on that laptop? Should I install the 32 bit version which automatically would use the x86 or is there a separate install file for that. Not sure if this is a dumb Q? Anythi...

I am trying to install TM1 on my laptop. Its is 9.5.1 64 Bit. In the choose a product to install, I do not get an option for TM1 perspective. In the past when I installed the 32 bit version I used to get that option. Not sure if it is a 64 bit problem. I am getting a similar problem for 9.5.2. Thank...

thanks guys, this is a great starting point...