Home
Help
Search
Calendar
Login
Register
The largest independent IBM Cognos collaboration community - Brought to you by BrightStar Partners and BSP Software!
News:
Stay connected throught Twitter, LinkedIn, Facebook and YouTube. Check out the latest IBM Cognos tips and tricks in the BSP Chronicles. Join our Mailing List.
Recent Posts
1
Cognos Connection, Viewer, Scheduler / Re: Paste Icon on Cognos Connection
« Last post by Michael75 on 24 May 2013 04:45:09 pm »@ MFGF
I think that I have given you all the info you requested
Thanks!
Michael
I think that I have given you all the info you requested
Thanks!
Michael
2
Report Studio / Re: Date Prompts Filters/Slicer in DMR models
« Last post by Cognos Talk on 24 May 2013 01:51:55 pm »Thank you very much for this useful information. However i could not make it work properly, my data item (filter) gives me an error, can you kindly take a look inside, i am attaching report itself the query is called MCI.
Also should i continue and use date from and date to or use date range parameter that will cover the range???
Thank you in advance for your help
Also should i continue and use date from and date to or use date range parameter that will cover the range???
Thank you in advance for your help
3
Cognos Administration / Default Email Options
« Last post by Lynn on 24 May 2013 12:53:32 pm »I am not an admin and I do not play one on TV....
My users asked if the default option when setting email options be changed to "Attach the report" rather than "Include a link to the report" when scheduling. Oddly, I find the default already is "Attach the report" for every other place you can edit email options *except* via scheduling. If you run with options from Cognos Connection or select email from Cognos Viewer it always comes up with attach the report as the default. I can't imagine why it would be different in scheduling, but it sure is in our installation (10.1).
I don't see anything in the documentation that covers altering this default, only that you can hide the "Attach the report" option entirely.
Any thoughts on what this would take to do?
My users asked if the default option when setting email options be changed to "Attach the report" rather than "Include a link to the report" when scheduling. Oddly, I find the default already is "Attach the report" for every other place you can edit email options *except* via scheduling. If you run with options from Cognos Connection or select email from Cognos Viewer it always comes up with attach the report as the default. I can't imagine why it would be different in scheduling, but it sure is in our installation (10.1).
I don't see anything in the documentation that covers altering this default, only that you can hide the "Attach the report" option entirely.
Any thoughts on what this would take to do?
4
Active Reports / Re: Active report doesn´t load on Ipad although it runs fine on Cognos Connection
« Last post by leojzamboni on 24 May 2013 11:45:15 am »28 MB
The email atatch limit is 50 mb. The app finishes the download fine.
The email atatch limit is 50 mb. The app finishes the download fine.
5
Active Reports / Re: Active report doesn´t load on Ipad although it runs fine on Cognos Connection
« Last post by MFGF on 24 May 2013 11:38:17 am »How big is the rendered MHT file?
6
Report Studio / Re: Difference two metrics with cubes
« Last post by MFGF on 24 May 2013 11:36:33 am »Hi all,
I have a problem with a calculation item based on the cubes in Cognos (Report Studio)
I have an metric that is formed with: METRIC = METRIC1 - METRIC2
- METRIC 1 = metric based on the prompt
- METRIC 2 = metrica based on the prompt - 12 month
How can I do to get the difference? Necessarily have to create 2 queries?
Please help me?
Can you be a little clearer on what you mean by "metric based on the prompt"? Do you mean the users can select which metric to use? Or do you mean that they are prompted for some dimensional information which is used as context for a specified measure?
Generally if you want to choose which measure to use, you can do this with a query calculation which builds up the MUN of the measure - driven by a prompt macro.
If you want to use a single measure with two different contexts, then you could use tuple() functions to get the measure value for the prompted member and the prompted member in the current year and the prompted member in the previous year.
Cheers!
MF.
7
Active Reports / Active report doesn´t load on Ipad although it runs fine on Cognos Connection
« Last post by leojzamboni on 24 May 2013 11:25:14 am »The report is quite complex, with three interactive tabs. Each tab contains a list containing a crosstab linked by master detail relationship. Those lists are filtered by three or four controls.
The active report processes in 10 minutes. It runs fine on Cognos Connection (IE 9), with great performance.
When I download the report to Cognos Mobile APP on IPAD, it simply doesn´t load. It keeps processing controls endlessly.
Thanks,
Leonardo
The active report processes in 10 minutes. It runs fine on Cognos Connection (IE 9), with great performance.
When I download the report to Cognos Mobile APP on IPAD, it simply doesn´t load. It keeps processing controls endlessly.
Thanks,
Leonardo
8
Report Studio / Re: Descriptions of javascript coding
« Last post by calson33 on 24 May 2013 11:22:30 am »Javascript is a very broad area. The best I can do is give you some links to help you get an intro into how it works:
http://www.w3schools.com/js/js_intro.asp
http://www.codecademy.com/courses/javascript-intro
http://www.adobe.com/devnet/html5/articles/intro-to-javascript-for-the-total-beginner.html
http://www.w3schools.com/js/js_intro.asp
http://www.codecademy.com/courses/javascript-intro
http://www.adobe.com/devnet/html5/articles/intro-to-javascript-for-the-total-beginner.html
9
COGNOS 8 Administration / Re: Performance Question - New Guy
« Last post by blom0344 on 24 May 2013 10:57:53 am »The query performance itself is just part of the whole story. Depending on the report design, the Cognos server may need to a little or a lot additional work.
You can check the individual queries by running the tabular data. If this is quick enough, then the slowdown may be due to the structure of the report. There are lots of performance killers. Probably the biggest one is the complex pageset, as it often means firing the same query over and over again.
Running aggregates are also real killers, as these are handled by the C server
Another strategy is to take the report and start simplefying the design and monitoring performance (make sure to flush cache each time). Also check the main report proces: BIBusTKServerMain.exe. Does it start to inflate to huge values in memory (or even worse : inflate / deflate / inflate / deflate ..)
Even with simple reports, the report will take obviously more time than the query
You can check the individual queries by running the tabular data. If this is quick enough, then the slowdown may be due to the structure of the report. There are lots of performance killers. Probably the biggest one is the complex pageset, as it often means firing the same query over and over again.
Running aggregates are also real killers, as these are handled by the C server
Another strategy is to take the report and start simplefying the design and monitoring performance (make sure to flush cache each time). Also check the main report proces: BIBusTKServerMain.exe. Does it start to inflate to huge values in memory (or even worse : inflate / deflate / inflate / deflate ..)
Even with simple reports, the report will take obviously more time than the query
10
COGNOS Planning / Re: Planning 8.4.1 - admin link from FM package to cube
« Last post by ericlfg on 24 May 2013 10:42:22 am »To expand on Mr J's post, you can only target development with an IBM package as the source in an admin link, the production option is greyed out. Following the run of the admin link, a GTP will need to be run to load the values transferred by the link. Give that a try (if you're not already doing so).
