PMsquare simplifies the complex challenge of architecting a data and analytics strategy that actually works. As an end-to-end solution provider, our team of analytics experts delivers through strategy, implementation, and ongoing support.
Our team is business-driven, prioritizing the business requirements and goals of your organization by building a tailored strategy around it, finding the best combination of technologies, services, and solutions.
Our cloud-first approach focuses on customers integrating the most scalable, cost-effective, and secure technological foundation to ensure long-term success & sustainability.
I hear that Framework Manager is also gone in CA 12, is that true? if so how about multi lingual reporting and Parameter Maps. Is there a way to achieve multilingual reporting without FM and its powerful macros? Analysis Studio was a great tool for discovering analytical concepts. I used it a lot. You need to equip the person doing the research with a research tool. What about cubes, is there a way to build cubes or is Cognos now only an ad-hoc reporting tool which is what I think.
1:12:21 to 1:16:33 is interesting - my experience in a production Cognos environment is that it can take 5+ minutes to failover. I am surprised you are expecting it to be much quicker.
I realize this is a bit dated now, but did the Cognos API itself ever get a video? I'd love to iterate and pull report spec from the API, you mentioned that as a possibility at about 10:15 in this vid, but I have yet to get it working through the cognos API test page.
Looked at your site Paul and always love you work. I believe the answer is no the viz tool tip does not work in "report". Too bad I have wanted that Tableau tool tip piece for some time.
Thanks for the information.. I'm using cognos 11.2.3 and Oracle version 19c with 64bit.getting logon failed When I click on the report. Could you please help me to make connection successful.. Error:: qe-def-0325 the logon failed for the following reason: rqp-def-0068 unable to connect to atleast one database during a multi- database attach to 1 database..etc Thanks
Hi I am a teacher : may I ask what would an equivalent on premise server computer for this sample done on aws calculator? This would be useful for students to work out on premise server cost to compare with.
Hi Jim, Although the type of server and the specs required for each business would be very different, here are some common general purpose servers for small businesses that could be compared to cloud costs. - Hpe ProLiant ML350 Gen10 High Performance - Tower - Xeon Gold 5218 2.3 GHz - 32 GB - Lenovo ThinkSystem SR850 V2 - Dell PowerEdge T640 Tower Server with 2 Intel Silver 8-Core CPUs, 128GB DDR4 RAM, 1.6TB Enterprise SAS SSD
Honestly I can't think of one. There's nothing in the code that ever calls back to home, no data is ever transmitted back to PMsquare or any other website. The code uses internal Cognos APIs, so it doesn't open the user to anything they can't already do. And if there are any features that the admins don't want users to have, there are a number of ways of preventing users from accessing them. There are two sides of CogBox, tools to make developer and admin lives easier, and tools to improve reporting and dashboarding. I can totally understand wanting the first to only be installed in dev or test environments (although personally I like having them in prod). Even that is possible with a minor modification to the specs.json in the zip file, and I intentionally leave that unobfuscated to make it easier to do exactly this.
I think eventually. The biggest problem for me is the lack of DMR. There are so many times where a simple dimensional expression can solve a complex relational problem. Once that gets in, I think I'll be far more comfortable saying we can start dropping FM.
@@PaulMendelson Other problem is that transformer is still the best option for managing high data volumes with millions of registers, so IBM should do a better job if they want replacing the old school mode.
I sorta crashed the party. It went something along the lines of, "Hey guys, great news! I'm totally going to take over your stream to talk about CogBox!". It turns out I can be a bit pushy at times.
I'm trying to follow along in the IBM cloud, however, when creating an account they are still prompting billing information. Is there any way to circumvent this?
Hi There thanks for the upload. It is really helpful. I have created a column Let's say column 'A' in Frame work manager and for the column expression I used the promptmany function to capture the value selected by user in the runtime and passed it as parameter to a stored procedure. So the expression of Column A something like this in FM : Stores procedure( Data Item 1, Data Item 2, promptmany()). Here Data item - 1 ans 2 are parameters of the stores procedure. Now coming to the main issue if i pull the newly created column A in Query Studio and run it as Excel/PDF/CSV a prompt page is created thanks to the usage of promptmany function in the column definition, after selecting a value from the prompt when click on OK nothing happens i just get a message in the screen saying Loading please wait then again back to the prompt page with no error . But the expected output is after clicking any value from the prompt it should generate the report file in the format that I have selected either (Excel/Excel data/PDF). However the report does run successfully in HTML format. Can you please tell me what shall i do to make the prompt work and be able to download the report output. One more thing a pulled the same column A to a list in report studio and able to generate report in Excel and PDF format. It is not working in Query Studio only. Please help me with this issue
Macros give you a huge range of additional options. Unlike standard prompt aliases (?P_Product?) prompt macros allow you to define default values and expression fragments. For example you could do something like: [Year] = #prompt('p_Year','integer',timestampMask($current_timestamp,'yyyy'))# If nothing is passed to the p_Year parameter the macro will default to the current year. You could also use query functions in there as well. [Year] = #prompt('p_Year','integer','year(getDate())')# Expression fragments are also a huge part of macros. Token prompts allow you to modify expressions with a parameter. Consider this: #prompt('topOrBottom','token','top')#Count([Regions],5,[Revenue]) the topOrBottom parameter, being a token, will turn that into topCount or bottomCount. Once you become comfortable with macros, I suspect you'll be using them far more often than aliases.
That being said there is exactly 1 usecase in which a prompt alias is better than a macro. Prompt aliases natively support in_range prompts, while macros do not.
@@PaulMendelson Hi There thanks for the upload. It is really helpful. I have created a column Let's say column 'A' in Frame work manager and for the column expression I used the promptmany function to capture the value selected by user in the runtime and passed it as parameter to a stored procedure. So the expression of Column A something like this in FM : Storedprocedure( Data Item 1, Data Item 2, promptmany()). Here Data item - 1 ans 2 are parameters of the stores procedure. Now coming to the main issue if i pull the newly created column A in Query Studio and run it as Excel/PDF/CSV a prompt page is created thanks to the usage of promptmany function in the column definition, after selecting a value from the prompt when click on OK nothing happens i just get a message in the screen saying Loading please wait then again back to the prompt page with no error . But the expected output is after clicking any value from the prompt it should generate the report file in the format that I have selected either (Excel/Excel data/PDF). However the report does run successfully in HTML format. Can you please tell me what shall i do to make the prompt work and be able to download the report output. One more thing I pulled the same column A to a list in report studio and able to generate report in Excel and PDF format. It is not working in Query Studio only. Please help me with this issue
@@prabhuprasadpanda2729 I honestly don't know what's going on there. Which version of Cognos are you using? Which browser? Query Studio has been out of support for a while, and it may be that the prompting mechanism Cognos uses no longer supports it. It also uses some quirks of Internet Explorer, so it doesn't always behave correctly in modern browsers. What I would do in this case is to open the browser developer toolbar, go to the network tab, and then look for browser requests going to the server. If there's a failed request, it would go a long way to explaining what's going on. It's been years since I've touched query studio. If you can set parameters directly onto the object, try doing that. It sounds like the error is happening during setting the parameter, so if we can bypass that point it should work.