problem with different data in report studio and TI process

Post Reply
em_past
Posts: 19
Joined: Tue Jan 29, 2013 11:11 am
OLAP Product: none
Version: 10.1
Excel Version: 2007

problem with different data in report studio and TI process

Post by em_past »

Hi, i'm new here.
I've got a problem:
i see differrent data in report studio and my cube after importing data to it. I import data from SAP BW.
I need a product description. And in SAP there are two columns with English and Polish description. In Report Studio i see correct data (Polish description) but in my cube there is description in English.
So it looks like TI proccess connect to bad column, but why and if it is possible? How can i check it?
Off course i use the same package.

Any suggestions?
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: problem with different data in report studio and TI proc

Post by tomok »

em_past wrote: So it looks like TI proccess connect to bad column, but why and if it is possible? How can i check it?
Didn't you create the TI process?????? Just open it up and change the variable you are loading to the description attribute from the English column to the one where the Polish is.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
em_past
Posts: 19
Joined: Tue Jan 29, 2013 11:11 am
OLAP Product: none
Version: 10.1
Excel Version: 2007

Re: problem with different data in report studio and TI proc

Post by em_past »

i did a proccess but i haven't English dimension in attrribute tab. It is special SAP function that you can set language according to what you have selected in your package.
But what i'd like to know is why i have differrent data in Report Studio and after importing to cube from the same package? TM1 sets some default values differrent than Report Studio?
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: problem with different data in report studio and TI proc

Post by tomok »

em_past wrote:TM1 sets some default values differrent than Report Studio?
By "package" I assume you are talking about Framework Manager? Please be aware that Cognos BI (of which Framework Manager is a part) and TM1 are two separate products. It is entirely possible that TM1's ability to see data in a Framework Manager package is slightly different than that of BI. I'm not very experienced in Framework Manager so I can't help you with this one.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
em_past
Posts: 19
Joined: Tue Jan 29, 2013 11:11 am
OLAP Product: none
Version: 10.1
Excel Version: 2007

Re: problem with different data in report studio and TI proc

Post by em_past »

thank you for your response.
it works like i thought that when i have selected language for package in FM as 'English', in Report Studio i see values for English description. So i think that i have change language in TM1 to Polish, but it is not easy for me... I tried change language values in differrent configurations files but it is nor working. Do you know how can i check which lang is used in TM1? Is there some function for check it?
em_past
Posts: 19
Joined: Tue Jan 29, 2013 11:11 am
OLAP Product: none
Version: 10.1
Excel Version: 2007

Re: problem with different data in report studio and TI proc

Post by em_past »

OK i fixed the problem - i had to change language for USER who run TM1 server proccess.
You can change it in Windows Services tab -> server on which you're working -> properties -> check user
Post Reply