List of Contributions

Buddhi Gupta

Contact Details

My Content

1 to 20 of 50+ total

RE: HINT: add comments to your Report QueryItems

Posted By Buddhi Gupta Tue January 05, 2021 10:04 AM
Found In Egroup: Cognos Analytics \ view thread
Yes it's Cognos 8 feature. I hope it can be improved to use standard commenting method used in Data Modules or May be adding a Comment property to each Data item and query would make it easy to document XML spec. ------------------------------ Buddhi Gupta ------------------------------

Remove specific Output Option

Posted By Buddhi Gupta Fri December 18, 2020 04:51 PM
Found In Egroup: Cognos Analytics \ view thread
Hi All, After a report is rendered in html; on Play button we have multiple format options for reports to be downloaded. Is there any way to Hide this button or remove specific report format such as XML? Thanks for inputs! ------------------------------ Buddhi Gupta ...

RE: Report and Query Execution Time

Posted By Buddhi Gupta Wed November 04, 2020 03:36 PM
Found In Egroup: Cognos Analytics \ view thread
This option is only while authoring report. You should look Audit database for query execution time for consistency. You may also use Console log/Network of Browser to see where it's taking time for rendering objects and compare with times shown on report. ------------------------------ Buddhi ...

RE: Event Studio - Cloud alternative?

Posted By Buddhi Gupta Wed November 04, 2020 03:21 PM
Found In Egroup: Cognos Analytics \ view thread
Probably you can use Bursting to compare for condition and send to dummy email when there is no threshold reached and send to proper email id when threshold value is reached. ------------------------------ Buddhi Gupta ------------------------------

RE: Importing Excel into Data Module via Schedule

Posted By Buddhi Gupta Wed November 04, 2020 03:17 PM
Found In Egroup: Cognos Analytics \ view thread
As per my understanding, It can be done with help of Jupyter Notebook or REST API in CA 11.1.7. ------------------------------ Buddhi Gupta ------------------------------

RE: Data Module Union Query

Posted By Buddhi Gupta Wed November 04, 2020 03:14 PM
Found In Egroup: Cognos Analytics \ view thread
I tried by creating calculation on final Union query but it didn't work. Only work around is to recreate Union and change identifier to original Union to avoid impact to subsequent Models. It would have been great to provide interface for Join, Union similar to when we create View to be able to modify ...

Data Module Union Query

Posted By Buddhi Gupta Tue November 03, 2020 02:21 PM
Found In Egroup: Cognos Analytics \ view thread
Hi All, I am not finding option to refresh union if I add/delete columns from base query subjects in Data Module. Is there any work around without recreating Union query after each updates? Thanks for any inputs! ------------------------------ Buddhi Gupta ------------------------------ ...

RE: Tool Tip in Dashboard

Posted By Buddhi Gupta Fri October 30, 2020 01:17 PM
Found In Egroup: Cognos Analytics \ view thread
Thanks @Brennan Fox! I have voted for the idea and put my comments there. ​ ------------------------------ Buddhi Gupta ------------------------------

Metadata for Report, Dashboard

Posted By Buddhi Gupta Fri October 30, 2020 01:10 PM
Found In Egroup: Cognos Analytics \ view thread
Hi All, Is it possible to extract metadata from Data Module, Dashboard, Dataset, Exploration (all json format) and report (xml) using REST API or have any limitations such as dependent on number of objects and size? Thanks for any inputs! ------------------------------ Buddhi Gupta --- ...

Data Module Version Control

Posted By Buddhi Gupta Tue October 27, 2020 02:34 PM
Found In Egroup: Cognos Analytics \ view thread
Hi All Does anyone have best practices for doing version Control for Data Modules? It will be great to have FM Script type of solution available to document changes and revert to prior version easily. Thanks! ------------------------------ Buddhi Gupta ------------------------------ ...

Dashboard Table column resizing

Posted By Buddhi Gupta Tue October 27, 2020 02:15 PM
Found In Egroup: Cognos Analytics \ view thread
Hi All I am not seeing option to resize column width, height in Dashboard Table and some text gets truncated. I do see in Exploration, I can resize column width. Am I missing option to achieve this in Dashboard? If not, is it going to be fixed to have better control on formatting in Dashboard. ...

Tool Tip in Dashboard

Posted By Buddhi Gupta Tue October 27, 2020 12:33 PM
Found In Egroup: Cognos Analytics \ view thread
Hi All Is there any way to add Tool Tip to include data item not in Dashboard Object? I am using CA 11.1.6. Thanks for any inputs! ------------------------------ Buddhi Gupta ------------------------------ #CognosAnalyticswithWatson

RE: Data Module shows no data

Posted By Buddhi Gupta Mon October 26, 2020 01:41 PM
Found In Egroup: Cognos Analytics \ view thread
What happens when you bring only one of error field in Data Module? You can also create a Native SQL Option using the view and see that fails. You can do cast in Native SQL and see if type incompatibility is causing the issue or something else. ------------------------------ Buddhi Gupta -- ...

RE: Clear Date Prompt in C11 using JS and Interactive Viewer

Posted By Buddhi Gupta Fri October 23, 2020 03:52 PM
Found In Egroup: Cognos Analytics \ view thread
Can you set it to a future date to make it work for your scenario? ------------------------------ Buddhi Gupta ------------------------------

Data Server Table Lists

Posted By Buddhi Gupta Fri October 23, 2020 02:57 PM
Found In Egroup: Cognos Analytics \ view thread
Hi All Is there any REST API based solution available to get Dataserver list of tables, loading metadata? Thanks for any inputs! ------------------------------ Buddhi Gupta ------------------------------ #CognosAnalyticswithWatson

RE: Past Activities are not listed in My Schedules and Subscriptions

Posted By Buddhi Gupta Fri October 23, 2020 02:27 PM
Found In Egroup: Cognos Analytics \ view thread
I don't see any schedule issue at our end in 11.1.6. ------------------------------ Buddhi Gupta ------------------------------

RE: Past Activities are not listed in My Schedules and Subscriptions

Posted By Buddhi Gupta Fri October 23, 2020 02:25 PM
Found In Egroup: Cognos Analytics \ view thread
I can see it's available in drop down (11.1.6): ------------------------------ Buddhi Gupta ------------------------------

RE: Report Scheduling

Posted By Buddhi Gupta Fri October 23, 2020 01:14 PM
Found In Egroup: Cognos Analytics \ view thread
Another option which may work is to use Event Studio:- You can create Event Studio with condition to check if day is 1st of 15th day and run the subsequent steps only when condition is met. This way you have to schedule only Event. ------------------------------ Buddhi Gupta ---------------- ...

RE: Report Scheduling

Posted By Buddhi Gupta Fri October 23, 2020 12:53 PM
Found In Egroup: Cognos Analytics \ view thread
For end users, Subscription option is available to schedule for desired frequency and filters in case that works. As standard practice, we will have daily/weekly/monthly jobs where you can add required reports to run and monitor. ------------------------------ Buddhi Gupta ---------------- ...

RE: Report Scheduling

Posted By Buddhi Gupta Fri October 23, 2020 12:06 PM
Found In Egroup: Cognos Analytics \ view thread
A possible work around... If you are on CA 11.1.7 and have External Application then you may possibly use REST API to trigger same report runs multiple times. ------------------------------ Buddhi Gupta ------------------------------