Search found 11 matches
- 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: 10148
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...
- 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: 10148
Re: How to change index in demension
Hi everyone!
Is there a way of changing dimension element index number via Turbo Integrator?
Thanks!
Is there a way of changing dimension element index number via Turbo Integrator?
Thanks!
- Fri Feb 01, 2013 12:22 pm
- Forum: Cognos Planning and BI
- Topic: Business Insight Workspace - Export to XML
- Replies: 0
- Views: 39852
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 ...
- 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: 5017
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
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
- 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: 5017
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...
- Mon Oct 22, 2012 7:57 pm
- Forum: Cognos Planning and BI
- Topic: Ancestor function Versus More than 1 parent
- Replies: 3
- Views: 49989
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' ...
- Mon Oct 22, 2012 6:24 pm
- Forum: Cognos Planning and BI
- Topic: Ancestor function Versus More than 1 parent
- Replies: 3
- Views: 49989
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...
- Fri Oct 19, 2012 11:35 pm
- Forum: Cognos Planning and BI
- Topic: Ancestor function Versus More than 1 parent
- Replies: 3
- Views: 49989
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-...
- Fri Oct 19, 2012 9:14 pm
- Forum: Cognos Planning and BI
- Topic: Report Studio & TM1 - selection by attribute
- Replies: 1
- Views: 42889
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...
- Mon Oct 08, 2012 4:55 pm
- Forum: Cognos Planning and BI
- Topic: Report Studio & TM1 - selection by attribute
- Replies: 1
- Views: 42889
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...
- 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: 2338
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
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