TM1 Forum

Hello, I've read your other posts regarding backward compatibility and I don't think the issue we have has been discussed. We are developing Cognos reporting using 10.2.1 (TM1 to build cubes/dimensions, Framework Manager and BI, Report Studio (dimensional reporting)). We have a client who has their ...

Hello, Below is a quick synopsis of my situation and how I plan to proceed. Please let me know if you have any suggestions or advice: We are a consulting firm. We have TM1, Framework Manager, BI - Report Studio, installed (actually 10.2.1) and configured. We have written a Report Studio report. Now ...

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

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

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

Hi Tom!

Please jump to my last post!

Deborah

Hi Tom, I'm sorry but when this is new it can be very confusing. So for example, the customer attribute Cust1Address would represent an intersection of all elements of all dimensions, Cust2Address would also represent an interasection of all elements of all dimensions. So in your example above, that...

Hello Tom! So it sounds like I just have to be patient and wait until I get Framework Manager and Report Studio up and running and then I should be able to pull the detail in at that point if I need to include it in a BI report, but probably using an ODBC connection to my Oracle database instead of ...

Hi Tom - I understand that. I used this type of schema when I developed a data warehouse in MS SQL. I had fact tables and dimension tables. The difference is my dimension tables did not have just one piece of data. My keys were stored in my fact tables, but the dimension tables had additional attrib...

Hi Tom - I really appreciate your experience and information - Thanks!! Two questions With your Customer Name example, where a measure is populated with the Customer Name attribute, would the memory difference between this and any other measure be the fact that one is a number and the other is a str...

Hello, There are at least two. I may find more uses as I begin actual development using TM1: First as an alias, which is one type of attribute. I think the purpose of an alias attribute is obvious. If not, there is a lot of information out there that would provide you with information regarding an a...

Hello, Thank you!! I just created 5 cubes in a test data model and for all but one (the one I had the questions on) I populated the cube directly using an ODBC connection to the data. I think I have a pretty good understanding of what the different methodologies are for me to get started without get...

Hello, Here's my reason: With a cube all the data for all dimensions must be brought in together - You can't bring in some dimension and then other's in another TI. Also you must bring in all consolidations (Year rows, month rows etc.). To do this I would write queries in my TI ODBC connections or i...

Hello,

I think there is something wrong with my second IF and it's not matching as expected. I put a value in the IF no match and my consolidation and leaf values were populated. Not quite as expected, but I believe this is the problem.

Thanks!

Deborah

Hi Declanar Thank you, that does makes sense. However, when I change to =N: (see below) before my first IF Statement I don't get anything. I've tried adding it right before the DB's instead, but I get an error. I think you're right that I must have to indicate this somehow though. ['InvTransQty'] =...

Hello, Here is my Rule: ['InvTransQty'] = IF(!mt_Time@=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); To summarize - The element InvTrans...

Hello, I am setting up an environment to develop reporting for Maximo. I have a good understanding of TM1 at this point and I am ready to start thinking about my data model. I ran across a Cognos Maximo Integration document today that provides information for Cognos Report Object Structures (ROS) in...

Hi Matt!

We have done that for all of the other TM1 services, but I am new here and do not have permissions to do this myself, so I have to contact someone to set the 'LogIn' for my new service to the service account we use. Right now this is a demo account, so it's ok.

Thanks,

Hello, All problems solved! Thank you again to those who responded!! Info below might help others: - Run cmd as an administrator to create or remove a service. - My login let me create the service, but apparently I didn't have permissions to actually run the service. I changed the LogIn for the serv...

Thank you both for your replies. Your information has been very helpful! I do have the ODBC Oracle DSN connection working and can pull data into the Application - Yeah!! I did try to change my application to a service. It created the service, but now it won't run, so another problem to solve. The tr...