TM1 Perspectives

[AliUgur]

Hi guys,

I m working on bank project. I created an excel report which reads the data from TM1 with DBRW function.One of my client opens the report and takes the data to report and saves it. Later on puts in a shared folder with other people. We use TM1 10.2.2 and excel 2010 version.

Manager does not have TM1 on her computer even TM1 add-in on her excel. She said today in the morning, she opened the report and saw the datas.

After afternoon, she opened the report again but she saw ?NAME# all the cells on the table.. Any idea?

[tomok]

Please tell me you are not really asking this question. You're a TM1 consultant and you don't even understand how Excel works in regards to automatic versus manual recalculation. When you have a sheet set to manual recalc what does Excel do when you open it?

[AliUgur]

yea I am a consultant :=). But, unfortunately ı m not really good on Excel. if its on manuel calculation, İt's not updating the report. And ı can see the data.

And ı think you are saying that if its on automatic calc, its directly calculates and you see hte ?NAME# error. İs it right?

But ı have another question. When we open the excel sometimes it asks UPDATE OR DO NOT UPDATE. If ı choose the DO NOT UPDATE. I need to see the data right?

Also, thanks for quick reply tomok..

[lotsaram]

yea I am a consultant :=). But, unfortunately ı m not really good

[anditadt]

Hi guys,

I m working on bank project. I created an excel report which reads the data from TM1 with DBRW function.One of my client opens the report and takes the data to report and saves it. Later on puts in a shared folder with other people. We use TM1 10.2.2 and excel 2010 version.

Manager does not have TM1 on her computer even TM1 add-in on her excel. She said today in the morning, she opened the report and saw the datas.

After afternoon, she opened the report again but she saw ?NAME# all the cells on the table.. Any idea?

You said that your manager doesn't have TM1 add-in / Tm1 Perspective installed in her excel.
It causes ?NAME# to occur, because Excel does not recognize the text in formula which using TM1 function.

So that your manager can see the data, you should paste value the data in excel file that you send
Or, you can use publish the data in tm1 web and let your manager see it there

[gtonkin]

If you are going to be saving templates in a share folder that contain TM1 formulae and could have data in them when saved, then I would recommend that you ensure that the template works, log out of your TM1 session then recalculate to remove the values reflected in the TM1 formulae. This will prevent users from seeing irrelevant data or data to which they should not have access.

Better yet, use Applications to store the templates to ensure only clients with TM1 can access. Consider what the TM1RebuildOption does for you too.

[AliUgur]

Thanks guys for reply. The point is in here as like tomok said manuel or automatic calculation. Not about string data or something like that. I have all DBRW functions and only number data.

If a user does not have TM1 Perpectives(TM1 add-in) and open an excel report(Which have DBRW function) can see the data if its on manuel calculation.

I just check the problem with customer. And the result, if a person does not have the TM1 on computer and wants to see the (DBRW function cells) data, the excel on his/her compter should have on manuel calc.

Thanks guys for help.

[tomok]

And the result, if a person does not have the TM1 on computer and wants to see the (DBRW function cells) data, the excel on his/her compter should have on manuel calc.

If the goal is to make TM1 Excel reports available to users without a TM1 license why not just use the Print Report functionality in Perspectives. It has the ability to save the reports as a snapshot which takes out the DBRW formulas.

[garry cook]

I genuinely cannot let this one go. I've been a member of this forum and it's predecessor for over a decade and have not come down hard on a post until this point. The issue is that this is not the kind of query where someone has been dropped into a difficult situation looking for help or a particularly technical point to be discussed between experts, you've come right out and said you're a consultant with a client and yet show a staggering lack of understanding of the most basic of concepts.

Your understanding of basic excel functionality (never mind the understanding of any form of the most simple TM1 functionality which less than an hour reading through the most absolute basic manuals on a system that you are taking money from a client to be a "consultant" in) is nothing short of jawdropping.

This kind of representation poisons the reputation of the software for everyone and although this ultimately rests with the company who is spending the money on your "expertise" and the kind of cost of everything / value of nothing approach that this entails, ultimately it is to the detriment of the software as a whole. You should spend some time getting to grips with the most basic of concepts before posting on a technical forum if for no other reason than for your own professional pride, especially if you are claiming to be a consultant.

[AliUgur]

Hi Tomok,
At the and of the project, ı created a report for customer. But, ı used their report excels. I just connected them to TM1 views . I didnt create new one. Because, they are using same excel reports maybe since 5 years. I didnt want to change their report pages. This is gonna be more easy for them.

[AliUgur]

Hi garry cook,

Your comment is totally wrong. I do not accept your ideas. I am a consultant since 2 years. Also, I know the basic stuff of excel and TM1. But sometimes, as like this situation ı can not see the customer's computer and ı don't know what they do. That's why ı wanted to get a clue from other people at the forum. I know this is technical forum. But one of the reason why people are here is to get help from people who knows better than us or people, also who have more experience. This time maybe ı came with a lot easy question which ı couldnt understand the problem because of some reason. Next time, I will help some of the people's question which can be alot easy or hard. The point on here to help people. I just wanted to ask, and take the people 's idea which ı couldnt think that time. That can be possible for anybody .

This is a forum which we can discuss any problem with the TM1. I believe

Thanks to everybody who helps..

[qml]

Ali,

As hurt as you must feel by Garry's remarks, there are probably many forum members that would agree with him wholeheartedly.

The issue you are raising here is at a level of difficulty that a paid consultant should be able to resolve it without outside help. Garry is not bashing you because you're asking newbie questions. He's just pointing out that it is your job to know basic things like this.

The fact that you have been doing it for 2 years and 5 months is not a good excuse. If a surgeon said to you "I don't really know what that pink squishy thing is, but I don't have to, I've only been doing this 2 years" you'd be outraged because you'd expect the doctor to get the basic training before he starts treating people! For money!

[AliUgur]

I am ok with the criticism. Tomok did the same thing and ı didnt answer him like this. Yea, after ı understood how it was easy and ı should know it. But the point is in here. gary's comment was too much in my opinion. People are here to learn from others who have more experience or who had that case before.

Anyway, thanks for helping and comments..

[jim wood]

I am ok with the criticism. Tomok did the same thing and ı didnt answer him like this. Yea, after ı understood how it was easy and ı should know it. But the point is in here. gary's comment was too much in my opinion. People are here to learn from others who have more experience or who had that case before.

Anyway, thanks for helping and comments..

Yes this forum is here to help people learn. Yes it's a resource to help people who are struggling. But here's the thing, it's not a resource to help you or your company make money when and where you shouldn't be. As QML said. You need to know the basics. But I'll tell you what, as we're doing your job for you (and effectively giving you training), could you let us know where we can send an invoice for our time? It's only fair as you're getting us to do your billable work for you.

[AliUgur]

"it's not a resource to help you or your company make money when and where you shouldn't be. As QML said. You need to know the basics. But I'll tell you what, as we're doing your job for you (and effectively giving you training), could you let us know where we can send an invoice for our time? It's only fair as you're getting us to do your billable work for you."

That's what ı am talking about what is wrong. I needed help even though it s basic. Anybody can be in my place, and will you be billing them. This is rude. You can say it was too easy. You should know it or you need to search first before asking or dont ask these kind of questions. But the way you treating is wrong. I just needed help thats all.

What are the reason's for forums people come and try to learn something or not?

[AliUgur]

Also, I am trying to help people here. İf ı see something ı can make comment or help anybody, ı do it. I couldnt understand why you guys treat like these.

We are here to learn more and teach more isnt it?

[jim wood]

"it's not a resource to help you or your company make money when and where you shouldn't be. As QML said. You need to know the basics. But I'll tell you what, as we're doing your job for you (and effectively giving you training), could you let us know where we can send an invoice for our time? It's only fair as you're getting us to do your billable work for you."

That's what ı am talking about what is wrong. I needed help even though it s basic. Anybody can be in my place, and will you be billing them. This is rude. You can say it was too easy. You should know it or you need to search first before asking or dont ask these kind of questions. But the way you treating is wrong. I just needed help thats all.

What are the reason's for forums people come and try to learn something or not?

It's a fair point. I would however say that the you need to understand something. A lot of the guys on here have been working with TM1 for quite some time. Since IBM bought it there have been a lot of "consultants" that have appeared out of nowhere undercutting the experienced guys and then come on here to get answers from the very guys they're taking work away from. That's difficult for anybody to swallow. I'm not saying this is you and it probably isn't, but if you read your post back it does sound awfully like that. Now that's not rude (neither was my previous post, direct yes, rude no) or confrontational at all. It's spelling out why you got the reaction that you did. There's no need to reply with excuses as it won't help anybody, just keep in mind what I've just said. If you do come back with excuses you're clearly not taking in what's been said.

[Steve Rowe]

I've locked this thread as I think that everything that needs to be said has been said and the issue resolved to boot!