Help TI problem using IBM Cognos Package Connector

[michael.cajucom]

Hi Guys,
We created a package(FM) which uses Virtual View Manager (SAP source), in the Business Insight advance and Report Studio it has no problems but when we use it in Turbo Integrator the dimension includes the dimension name on each element. What should i do so that i only get the actual elements from the source?

Sample Extracted elements are
-Posting Period:001
-Posting Period:002
-Posting Period:003

We don't want the "Posting Period:" in the element just the actual 001.

Thanks in advance.

Michael

[tomok]

Use a combination of the LONG and SUBST functions to strip off the dimension name at the start of the string.

[michael.cajucom]

Hi tomok,
When using IBM Cognos Package(SAP source) as a datasource in Turbo Integrator the variable and map tab are disable. I cannot do the ordinary advanced scripting. Any advice on this one?

Thanks

Michael

[lotsaram]

With the package connector you cannot in effect disable the wizard as there is no ability to set variable types to "other". You can however write your own code and do as you like by preventing the wizard code from being executed by placing the wizard code within an if statement. Then you can pretty much do what you like, including striping the dimension name from your elements.

bSkipWiz = 1;
IF( bSkipWiz = 0 );
#****Begin: Generated Statements***
The code you want to avoid is here
#****End: Generated Statements****
EndIF;
The code you actually want to execute you can write here!

[michael.cajucom]

hi lotsaram!
Thanks for the reply, i'll try to do this.
Another question is it possible to pass parameters in advance script for the prompts?
Thanks.

Regards,

michael

[lotsaram]

Another question is it possible to pass parameters in advance script for the prompts?

Have a look at the "Prompt editing" section of the 9.5.1 TI documentation.
http://publib.boulder.ibm.com/infocente ... GV309.html

[michael.cajucom]

Hi lotsaram,

No luck on following the guide using the API. I can't find a document for that API function, do i need to install something to use that CGAddPromptValues function?

Regards,

Michael

[lotsaram]

Hi lotsaram,

No luck on following the guide using the API. I can't find a document for that API function, do i need to install something to use that CGAddPromptValues function?

Regards,

Michael

I agree the documentation isn't as clear as it should be. The functions that are being referred to are new TI functions, you can use then on the prolog of your process. Nothing to install (provided you have at least 9.5.1)

[dsantos]

After you write the code to bypass the generated statements how do we know how TM1 is naming the variables (V1, V2, etc...) and the Attributes (V11, V12, V13...)? Can we rename them or how do refer to them so that TM1 understands what we want to use form the package?

Thanks

[rcolijn]

Hi there,

I am no way a TM1 person but we use the Package connector as well.

I think what you need to do is create an "Alias" whilst creating your dimesions via the Package Connector, its in the tab Data Source > Dimension > Attribute, just give it a name.

Then your View of your dimension can be changed using the little mask thingy and the drop down next to it.

Hope this helps, give me a shout if it did not.

ps, also when you pull the cube into FM assign "English" to that particular Alias before you publish the cube to BI.

[em_past]

Hi,
Do you know how can i set prompt bex value dynamically?
I tried with cgaddpromptvalue() function but it returns an error: invalid key.
Has anybody finished TI proccess correctly with this function?

[dr.nybble]

For CGAddPromptValue(), have a look here:

http://www-01.ibm.com/support/docview.w ... wg21614922

What I would recommend is to set prompt values through the UI. Then find the <process-name>.blb file in your TM1 Server data directory. Open it up in Notepad, locate the prompt entry and see how it is represented. You need to specify your prompt values in that form. (That is the TM1 Package Connector model file and will look familiar to anyone who has used Transformer...in fact you can even open it in Transformer!)