Search found 11 matches

by fcapell
Mon Feb 18, 2013 9:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to change index in demension
Replies: 8
Views: 10088

Re: How to change index in demension

Please forgive me for the lack of information in my previous post. I'm trying to sort a dimension by hierarchy and alphabetically by its alias attribute. This dimension is loaded from an Oracle database. I could sort the records and set the dimension ordering on 'ByInput'. But the Turbo Integrator p...
by fcapell
Mon Feb 18, 2013 6:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to change index in demension
Replies: 8
Views: 10088

Re: How to change index in demension

Hi everyone!

Is there a way of changing dimension element index number via Turbo Integrator?

Thanks!
by fcapell
Fri Feb 01, 2013 12:22 pm
Forum: Cognos Planning and BI
Topic: Business Insight Workspace - Export to XML
Replies: 0
Views: 39225

Business Insight Workspace - Export to XML

Hi everyone! Please forgive me if this is way too newbie... I've created a Business Insight Workspace (as well as the attached crosstabs and charts) and I want to move it to another environment (kinda moving from development to QA). I am able to save all crosstabs and charts specifications into XML ...
by fcapell
Tue Jan 15, 2013 3:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Select from Oracle Procudure in TI
Replies: 5
Views: 5000

Re: Select from Oracle Procudure in TI

Thank you tomok and bking101!

I've been in a hurry so I managed to put the queries right into Turbo Integrator and change the DataSourceQuery variable to put the parameters. It's running in a reasonable time, but I'll get back to this stored procedure approach later.

Best regards,

Fausto
by fcapell
Thu Jan 10, 2013 5:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Select from Oracle Procudure in TI
Replies: 5
Views: 5000

Re: Select from Oracle Procudure in TI

Hi everyone! I was searching the forum looking for a way of loading data into TM1 from an Oracle stored procedure (which is straightforward in SQL Server). I tried the sys_refcursor approach. I put "select function_name from dual" into TI screen and when I click on Preview, TI hangs and TM...
by fcapell
Mon Oct 22, 2012 7:57 pm
Forum: Cognos Planning and BI
Topic: Ancestor function Versus More than 1 parent
Replies: 3
Views: 49363

Re: Ancestor function Versus More than 1 parent

The funny thing is: I can bring the '2012_week_0' using TM1 subset screen. Here are the steps: [1] Click on View menu > Expression Window; [2] Click on Tools > Record Expression; [3] Click on 'All' button; [4] Click on 'Filter by Wildcard' button and type '2012-01-01'; [5] Click on the '2012-01-01' ...
by fcapell
Mon Oct 22, 2012 6:24 pm
Forum: Cognos Planning and BI
Topic: Ancestor function Versus More than 1 parent
Replies: 3
Views: 49363

Re: Ancestor function Versus More than 1 parent

Thank you for your reply, Michel. If you have multiple hierarchies you could combine the parent, ancestor (or ancestors) function in combination with the descendants function to pick the parent within the required context. I'm not sure if I got you, but I think you're suggesting that I kinda interse...
by fcapell
Fri Oct 19, 2012 11:35 pm
Forum: Cognos Planning and BI
Topic: Ancestor function Versus More than 1 parent
Replies: 3
Views: 49363

Ancestor function Versus More than 1 parent

Hi everyone, I'm a newbie working with Report Studio (Cognos 10.1.1) reading from a TM1 data source. I'm dealing with a Time dimension which has hierarchies like this: - 2012-01-01_YTD |-- 2012-01-01 - 2012-01-02_YTD |-- 2012-01-01 |-- 2012-01-02 [...] - Total 2012 per week |-- 2012_week_0 |-- 2012-...
by fcapell
Fri Oct 19, 2012 9:14 pm
Forum: Cognos Planning and BI
Topic: Report Studio & TM1 - selection by attribute
Replies: 1
Views: 42277

Re: Report Studio & TM1 - selection by attribute

Hi, Did anyone try to use roleValue function to retrieve the value of an attribute created in TM1? For example, I have created an attribute called "Last Year". So, I have create a report in Report Studio, put a data item containing the following expression: rolevalue('_lastYear', [Daily Sa...
by fcapell
Mon Oct 08, 2012 4:55 pm
Forum: Cognos Planning and BI
Topic: Report Studio & TM1 - selection by attribute
Replies: 1
Views: 42277

Report Studio & TM1 - selection by attribute

Hi everyone! I'm working with Report Studio (Cognos Express 10.1) accessing TM1 data. Please forgive me if my question is too basic, but I'm a newbie. I'd like to know if is there a way of selecting dimension members in Report Studio using attributes. I was assigned to create a report which will rec...
by fcapell
Wed Jun 13, 2012 10:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 API: evoking subset editor screen
Replies: 2
Views: 2331

TM1 API: evoking subset editor screen

Hi Everyone!

I have a C# Application and I need to provide a way for the user select a dimension element.

Is there a way to evoke the TM1 subset editor screen from a C# application?

Thanks,

Fausto