Hi
I have problem, i must give to user app where they can modify (add/modify) elements of dimension.
Issue is that this app must be available from the cognos portal site.
Could you give me advice of tm1 capabilieties in this field ?
Thank's
Cognos forms to configure data
-
PlanningDev
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
Re: Cognos forms to configure data
Depends on your version of BI and TM1 and how complicated you want to make it.
1. Easiest route, install iWidgets for BI so you can bring up a TM1 websheet inside the Cognos Portal. In your websheet using action buttons and parameters you could allow end users to modify a dimension.
2. More complicated, using stored procedures you can use a Report Studio Report with prompts that would pass the user input data in a database. Either poll the database on some interval to update your dimension based on changed data, or getting more complicated you may need to build a Java Servlet or .Net Web App that could be called from javascript to execute your process.
There are other complicated ways if you are willing to code with the API but just to keep it simple, you probably want route 1.
1. Easiest route, install iWidgets for BI so you can bring up a TM1 websheet inside the Cognos Portal. In your websheet using action buttons and parameters you could allow end users to modify a dimension.
2. More complicated, using stored procedures you can use a Report Studio Report with prompts that would pass the user input data in a database. Either poll the database on some interval to update your dimension based on changed data, or getting more complicated you may need to build a Java Servlet or .Net Web App that could be called from javascript to execute your process.
There are other complicated ways if you are willing to code with the API but just to keep it simple, you probably want route 1.