Urgent Help-Cognos TM1 10.2.2 Web Excel Format Need to Schedule Automatic to reach Common folder and email

Post Reply
abhishek.abhi10sri
Posts: 8
Joined: Tue Jun 24, 2014 4:19 pm
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: 2010

Urgent Help-Cognos TM1 10.2.2 Web Excel Format Need to Schedule Automatic to reach Common folder and email

Post by abhishek.abhi10sri »

Hi Experts

I am just looking out TI Script,rule, VBA code step by step to resolve following issue

issue -

Cognos TM1 10.2.2 Web Excel Format - how to Schedule Automatically to reach Common folder and user email every week on Friday.

Regards
Abhi
Wim Gielis
MVP
Posts: 3113
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Urgent Help-Cognos TM1 10.2.2 Web Excel Format Need to Schedule Automatic to reach Common folder and email

Post by Wim Gielis »

Good luck with your topic !
You don't show the least willingness to try to reach a solution by yourself, you just expect people to solve it for you. In addition you didn't bother to reply in your previous topic (http://www.tm1forum.com/viewtopic.php?f ... 774#p61774) so that does not trigger a lot of helpers either.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
abhishek.abhi10sri
Posts: 8
Joined: Tue Jun 24, 2014 4:19 pm
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: 2010

Re: Urgent Help-Cognos TM1 10.2.2 Web Excel Format Need to Schedule Automatic to reach Common folder and email

Post by abhishek.abhi10sri »

Hi Wim,

I know we can do it through Architect but My question is whether its possible Automation from TM1 web
also this is some thing my QV developer needs direct connection From tm1 cube view .
do you know any connector or way to use TM1 Cube as data source in QLIKVIEW . I Know we have connect manager which required extra cost.
Now may be you going are going to suggest me about write MDX query for QV report but you know writing MDX query required more work.

Thanks :)
abhishek.abhi10sri
Posts: 8
Joined: Tue Jun 24, 2014 4:19 pm
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: 2010

Re: Urgent Help-Cognos TM1 10.2.2 Web Excel Format Need to Schedule Automatic to reach Common folder and email

Post by abhishek.abhi10sri »

This is resolved .

I have created TI process for generating csv file then scheduled via Chore
Then i asked my IT team to provide me SMTP for email configuration detail .

So chore is generation csv file

then i scheduled csv via windows scheduler .

Thanks
Abhishek
Wim Gielis
MVP
Posts: 3113
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Urgent Help-Cognos TM1 10.2.2 Web Excel Format Need to Schedule Automatic to reach Common folder and email

Post by Wim Gielis »

Thank you for the update.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply