TM1 Forum

DHaagenson wrote:I'm sorry but when this is new it can be very confusing.

That's why I recommend a training class. I don't have the time or patience to teach you how to use TM1 via forum posts.

Hi Tom!

Please jump to my last post!

Deborah

Hi Tom!

Is my problem that I am pulling the attributes from the cube instead of from the dimension using the ATTRN or ATTRS functions? Is pulling them from a cube causing this huge number of copies?

For example, I changed my rule to use ATTRS and ATTRN instead of pulling the attributes from the cube:

WAS:

['InvTransQty'] = N:IF(!mt_Time:'Months'@=DB('}ElementAttributes_mt_InvTrans',!mt_InvTrans,'Month'),IF(!mt_InvTransTypes@=DB('}ElementAttributes_mt_InvTrans',!mt_InvTrans,'TransType'),DB('}ElementAttributes_mt_InvTrans',!mt_InvTrans,'TransQty'),0),0);

NOW:

['InvTransQty'] = N:IF(!mt_Time:'Months'@=ATTRS('mt_InvTrans',!mt_InvTrans,'Month'),IF(!mt_InvTransTypes@=ATTRS('mt_InvTrans',!mt_InvTrans,'TransType'),ATTRN('mt_InvTrans',!mt_InvTrans,'TransQty'),0),0);

Please don't scrutinize the nested If's. I realize I may be able to simply that. I am just concerned about the attributes.

Thanks!

Deborah

Hello Deborah,

It doesn't make a difference, ATTRS or DB to the control cube. In the background TM1 will do the same work.
As suggested by Tom, please do yourself a favor and book a good TM1 training. Figuring out all this without training will be time consuming and cost a lot of effort too.

Hello,

Thank you for the info!

I see a lot of posts lead to the fact that we all need training - hum? I would imagine all of us posting to this site are learning. Many of us work for companies where training is not provided and even if it were most of it's a waste of time. It's usually very basic and doesn't address the type of issue that I just posted. If you can recommend a good training class for someone at this level I would appreciate it. Solutions are what we need, not intimidation and demeaning rederick.

Regarding my issue - DB functions to access cube elements are used often from what I can tell. An Attributes cube is just another cube from what I can tell. Also, so pulling elements from a dimension is no different than pulling from a cube?

I don't expect another response, but I wanted to post this for others to see, because it might help them.

Thanks Again!

Deborah

I thought I would have one crack at explaining this with a simple 3d cube dimensioned by account / month and measure

The account dimension has these attributes The cube has this data, note the sparsity, the blank cells do not exist in the cube and do not use resource. If I pull the attributes into the cube I get this. This data is now fully dense and all cells are populated with strings, which use more space than data but that's not the point, it is the lose of sparsity that is the real issue. This is where the responders are trying to point where your design is going wrong, as this example scales in a production system you will grind to a halt.

I'm not going to tell you what you are doing wrong because it is possible you are not, all I can tell you is that I've been doing this a long time and.
1. I've never pulled attributes into a data cube.
2. Stored strings in a data cube.

Rather than getting buried in design and relational / multi-dimensional terminology maybe if you explain the business requirements and someone can suggest the right way of going about it? Unlike the relational world the best design in TM1 can rarely be assessed independently of the reporting or calculations that are expected to be delivered by it.

Cheers

Hello,

This began as a post of mine a while back. Just a quick note in case anyone else is wondering - I found that when I developed my Report Studio report I could easily pull the attributes onto my report without having to bring them into my cube in TM1. It's too bad that someone didn't know or think to tell me that, but in any case thank you for the help you did provide.

DHaagenson wrote:It's too bad that someone didn't know or think to tell me that, but in any case thank you for the help you did provide.

It's also a pity you did not describe better what you were trying to do. There is no mention of Cognos BI in your original post. There is some mention of Framework Manager and Report Studio in later posts, but it can be easily missed or misinterpreted. I remember reading this thread back when it was active and thinking that the answers you were getting were pointing you in the right direction because it never dawned on me that you were trying to solve a non-existent problem.