Recent Posts

Pages: [1] 2 3 ... 10
1
Report Studio / Driving Queries
« Last post by RandyM on Today at 06:36:40 pm »
I have a report that contains 4 lists that all have the same content but are each filtered differently by just one field (say code=A, B, C & D).  The query structure for each list is exactly the same and is made up of about 10 queries with numerous joins (not simple).  Without copying the somewhat long list of queries 4 times, is there a way to drive the one query structure to run for each List? 
2
Report Studio / Including attributes in the crosstab report
« Last post by cognos4321 on Today at 05:14:19 pm »
Hello,

We have TM1 cubes as database in my company
I am creating a crosstab report in report studio where I am suppose to get some information from attributes in a hierarchy.
I added them on the row of the crosstab and it gives me error.

Could anyone please help me how do I get attributes included in a report in report studio.

Thanks in advance
3
Framework Manager / Re: Cognos aggregation - listagg
« Last post by ry1633 on Today at 03:10:29 pm »
wow - I wouldn't have thought to look there.  I did find it but the menu option to turn on native SQL is grayed-out for me.
4
Framework Manager / Re: Cognos aggregation - listagg
« Last post by bdbits on Today at 03:08:23 pm »
5
Content Explorer - Portal / Re: Order folders and entries
« Last post by bdbits on Today at 03:01:04 pm »
Bonus points for "TPS report" reference!  Hahahahaha.... :D

If you work in corporate America and have not seen Office Space, you should. :)
http://www.imdb.com/title/tt0151804/?ref_=nv_sr_1
6
Framework Manager / Re: Cognos aggregation - listagg
« Last post by ry1633 on Today at 02:55:37 pm »
I thought about trying Native SQL too.  But I can't quite figure out where to enable it.  If I right-click on my datasource to Create -> New Query Item - I don't see any place to enable native SQL.  I'm using Framework Manager 10.2.1
7
Can you mass add the windows font folder in Cognos 11. I am able to add individual font, but would like add the entire folder.
8
Report Studio / Re: Stored Procedures in Cognos Reporting
« Last post by bdbits on Today at 02:47:56 pm »
Of course it should be noted that writing SQL in Report Studio goes against many reasons for using Cognos in the first place. If your vendor actually understands Cognos, they would not want you to do this either.

You should only do it as a last resort, which may be the case here.
9
Framework Manager / Re: Cognos aggregation - listagg
« Last post by bdbits on Today at 02:40:25 pm »
What Lynn suggested with a view should work in any case. That aside, have you tried native or pass-through SQL? Because that should work.

https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_fm.10.2.2.doc/t_change_sql_type.html#change_sql_type
10
Active Reports / Data radio button group
« Last post by Arumugam on Today at 11:39:47 am »
I have doubt on data radio group button in active reports.i have query item which gives two currency values (dynamic) which works well in FM and tabular data but when I pull the query item for radio group it takes all value from the table..Any idea/suggestion?

Sent from my Moto G (4) using Tapatalk

Pages: [1] 2 3 ... 10

           
Twittear