Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Query Studio => Topic started by: ry1633 on 22 May 2015 01:25:21 PM

Title: Query Studio - grouping and summarizing with running totals
Post by: ry1633 on 22 May 2015 01:25:21 PM
Hi all,

I'm new to Query Studio (I've only worked with Report Studio before) - some of my users have the need for ad hoc reports they run themselves, so I am starting to work with QS.   I have a question.  How do you creating running totals inside grouped columns with a final total at the bottom.  This is fairly easy in Report Studio, but seems murky at best in Query Studio.  Maybe it's not even possible?
Title: Re: Query Studio - grouping and summarizing with running totals
Post by: bdbits on 22 May 2015 02:59:00 PM
Since Query Studio is officially being deprecated (unavailable) after 10.2.2, I would strongly advise you to look at Workspace Advanced instead.
Title: Re: Query Studio - grouping and summarizing with running totals
Post by: ry1633 on 29 May 2015 11:34:01 AM
oh wow.  I didn't know that.   If I need ad-hoc capability for reporting, will I have to use Workspace Advanced now?   I've got a bunch of practice stuff in Report Studio.  How easy/hard is it to migrate that into Workspace Advanced?
Title: Re: Query Studio - grouping and summarizing with running totals
Post by: bdbits on 29 May 2015 02:46:34 PM
Workspace Advanced is pretty easy to pick up. But it is not designed to replace Report Studio, which is not being deprecated.

They share the same spec, so you can open reports in WSA using Report Studio, and vice versa.
Title: Re: Query Studio - grouping and summarizing with running totals
Post by: ry1633 on 01 Jun 2015 04:14:48 PM
Ok thanks, I will wade and poke around with Workspace.   Why did Cognos do away with Query Studio?
Title: Re: Query Studio - grouping and summarizing with running totals
Post by: Michael75 on 02 Jun 2015 06:05:55 AM
A good explanation can be found here: http://info.motio.com/Blog/bid/106877/IBM-is-Deprecating-Query-Analysis-Studio-Got-a-Migration-Plan (http://info.motio.com/Blog/bid/106877/IBM-is-Deprecating-Query-Analysis-Studio-Got-a-Migration-Plan)
Title: Re: Query Studio - grouping and summarizing with running totals
Post by: ry1633 on 02 Jun 2015 01:54:35 PM
thanks this is good info to have.  I've only started learning Cognos so I don't any reports built in Query Studio yet (I was just playing around with it).  My org may have need some adhoc reporting so I will delve into Workspace some more.
Title: Re: Query Studio - grouping and summarizing with running totals
Post by: Michael75 on 03 Jun 2015 12:59:59 AM
A quick reply on terminology...

QuoteMy org may have need some adhoc reporting so I will delve into Workspace some more.

I'm sure you know this already, but Cognos Workspace exists, and is a very different product. What we're talking about here is Cognos Workspace Advanced.
Title: Re: Query Studio - grouping and summarizing with running totals
Post by: Michael75 on 06 Jun 2015 08:09:36 AM
@ ry1633

I didn't have the link to hand when I last posted, but here's the official message on AS & QS deprecation from IBM Cognos:

https://www-304.ibm.com/connections/blogs/basupportlink/entry/query_studio_and_analysis_studio_deprecation?lang=en_us (https://www-304.ibm.com/connections/blogs/basupportlink/entry/query_studio_and_analysis_studio_deprecation?lang=en_us)
Text only | Text with Images