Do selections of dimensions in excel and run export process

[A.Pete]

Hi

Im trying to create an export from a cube view that should populate Cognos Controller Staging tables. I would like the users to do a select and click from excel and then use that excel in Tm1Web (that is then integrated into cognos 10 BI). The key points for the users are:

1. Create selections and multiple selections from existing dimensions, For instance multiple period values
2. Click a button that will run a TI-process that populates staging tables.

So my questions are:
Is this possible using active forms or similiar?
How should the view be created when users select multiple elements?
Am I on the wrong track here? I'm open for more creative ideas

Thanks in advance.
/Peter

[Neil Watson]

Hi Peter,

If the need is for a user to push data into a sql table via the web then yes I believe this is possible.

The web form will need to have all of the parameters easily definable.
e.g. For Periods
Column A P1, P2, P3 etc,
Column B Export or blank (you can still use data validation on the web)

Create an Action button that will take the Period selections, ("Export" or blank) as parameters.
This action button will run a TI process that,
creates the source view with the passed in paramters in the Prolog tab
then via ODBC will create an "INSERT INTO" sql statement in the data tab

Heop this helps and/or gives you ideas
Cheers
Neil