Recent Posts

Pages: [1] 2 3 ... 10
1
Framework Manager / Re: How to create calculations in the DMR model
« Last post by Deep750 on Today at 06:00:27 am »
Should be straight forward, create the items in DMR-layer, and base the calculations on these items.
2
Reporting / top percent olap
« Last post by cognos05 on 09 Aug 2020 06:08:09 pm »
Hi ,

Is there a equivalent expression instead of using top percent for cognos olap .

I woulld like to find the list of materials who contribute towards sale that is greater than 80 percent and less than 95 percent.

Except(topPercent (filter([Agency Sales Cube].[Items].[Items].[Item],Total([Qty] within set set([2019/Jul],[2019/Aug],[2019/Sep],[2019/Oct],[2019/Nov],[2019/Dec]))>0),95,[H0 Sales]),
topPercent (filter([Agency Sales Cube].[Items].[Items].[Item],Total([Qty] within set set([2019/Jul],[2019/Aug],[2019/Sep],[2019/Oct],[2019/Nov],[2019/Dec]))>0),80,[H0 Sales]))

The above expression is working but its not 100 percent right because the toppercent ranks the items based on a measure and if the measure has same value it considers in one group . I would basically like to know how can top percent be written in another form of expression manualy

3
Framework Manager / How to create calculations in the DMR model
« Last post by Cognosnewbie26 on 07 Aug 2020 04:39:07 pm »
Hello,
I wanted to create a calculation in the DMR model which is basically calculating the variance% of amounts between current year and prior year. For e.g

Amount of CY - Amount of PY
----------------------------------   * 100
Amount CY

How do I achieve this?
4
An alternative to hard-coding SQL like this (which isn't a best-practice) is to create a Query Set from two existing query subjects. You will end up with the same result, but the former will result in metadata callbacks, whereas the latter will not (and so will potentially be more efficient).

Cheers!

MF.

Thanks for the suggestion. Since I am new I am definitely interested in knowing the best practices. However in this case I think that I did need a custom sql because the custom hierarchy needed some conditional statements.
5
Right.  Cognos will frequently not clean up its own messes.  I have a routine that runs daily that deletes anything over 3 days old from the temp folder.  I also track Windows resources graphically by using Performance Monitor to write the data to a CSV file every 15 seconds, 12 hours a day, and a web page for the presentation.  That way I know if my Temp drive (I have a separate drive just for Cognos temp) is filling up or if Filter Conditions is attempting a hostile takeover of the CPUs without needing to crack open Remote Desktop.
6
thanks Dougp for your insight.

Yes, it will be a VM with 4 cores 8 processes.
Im sure it will be CQM and DQM so i guess with this server capacity my proposal would be just fine.

Quote
My main resource problem is the temp space required when Cognos is compiling a large CSV or Excel file because a user decides Cognos is a good ETL tool.


*  Filter Condition dialog against a field with many distinct values in Cognos 10.2.1 - 11.0.13 can cause 100% CPU usage.  It's really fun when a classroom full of users all do this at once.  100% of all CPUs are used and all I can do is unplug the server from the power grid.  I have verified it is fixed in 11.1.7.

ugh! tell me about it! i have several customers doing this. Just imagine they are running large Excel file and running their datasets refresh all at the same time. Worse, sometimes the temp files are lingering even after the report/dataset have finished execeuting. Sometimes even sql process lingers because of this. That's why i always watch out for the temp dir size and cleans them periodically.

I have a system on 11.0.13 as well. So i feel you!
7
Some of the following is guess work.  Your mileage may vary...

4 physical cores or 4 logical cores?  Windows (and I assume Linux) will use hyperthreading (or...?) to turn 4 physical cores into 8 logical cores.
Or is this a VM with 4 "cores" assigned?

With 4 cores, you should be able to run 4 BI Bus processes (Maximum number of processes for the report service during peak hours).  But that's for CQM.  If you are also using DQM, the query service will be competing with that.  Also, the operating system may need to compete for resources.  So, if you have 8 logical cores, you could reasonably have up to 6 BI Bus processes, but if you have 4 logical cores, maybe 3 is better.

On my system, I have about 2500 users total, 250 users per day, and have (rarely) seen a max of about 20 concurrent users (actively running reports at the same time).  I use 4 processes and 4 connections per process (so I may have had 4 users queued for a few seconds at one point).  I only run into CPU capacity problems with a Cognos bug condition is hit.*  Other than that, I'm usually running at about 5% CPU usage.

My main resource problem is the temp space required when Cognos is compiling a large CSV or Excel file because a user decides Cognos is a good ETL tool.


*  Filter Condition dialog against a field with many distinct values in Cognos 10.2.1 - 11.0.13 can cause 100% CPU usage.  It's really fun when a classroom full of users all do this at once.  100% of all CPUs are used and all I can do is unplug the server from the power grid.  I have verified it is fixed in 11.1.7.
8
Cognos Administration / Sophos Blocking IBM Cognos Configuration 10.2.2
« Last post by KRees on 07 Aug 2020 12:00:57 pm »
We use a data warehouse to create student data reports which runs on IBM Cognos 10.2.2.  Sophos is somehow causing the Cognos Configuration service to fail.  Wondering if anyone else has experienced this issue and how they resolved it.

Here is what I have tried:

  • Created a new threat protection policy in Sophos to include a folder and process exclusions for D:\Program Files (x86)\ibm\cognos\c10\ and D:\Program Files\ibm\cognos\c10_64: Cognos Configuration failed
  • Stopped hitmanpro.alert in task manager as the data warehouse engineer was thinking that this component was causing the issue: Cognos Configuration failed
  • Uninstalled Sophos completely: Congos Configuration was successful with no failures
  • Re-installed Sophos and added a folder and process exemption for entire C:/, D:/, and E:/ drives on all involved servers: Cognos Configuration failed
  • Turned off each individual component/service on the local Sophos installation: Cognos Configuration failed every time

I looked at the cogserver.log and pogo_2020-08-06.log files. Everything points to failure at the com.cognos.pogo.reportservice.ProcessManager, which appears to be the external report server.  Doing some research I came across the following website: Control Center can not launch Cognos Report.  The article has the same error message I'm seeing in the cogserver.log file.  The resolution is to install the missing libraries, libgcc and libstdc++ so that LDD comes up clean against BiBusTkServerMain and BMTMDProviderMain.

  • Based on this information, I changed the Sophos policy to not prevent DLLs loading from untrusted folders and disabled Protect processes: Cognos Configuration failed


At this point, I have no clue what the issue is or how to fix it.  Has anyone else run across this or have ideas on what I should try next?  I have tried everything I can think of that would help pinpoint the root cause but am still coming up short.
9
Just want to check or get feedback from experts.
i am trying to propose tuning settings for a deployment that has 2 dispatcher server.
Each dispatcher server has 32GB RAM with 4 CPU cores.

Here's my recommendation based on 360+ users :

maximum memory for Websphere Liberty profie : 16GB (could be more)

Number of high affinity connections for the report service during peak period = 2
Number of low affinity connections for the report service during peak period =8
Maximum number of processes for the report service during peak period=4

I reiterated these are just the starting configurations. I believe based on the current server resource we could still increase these settings.
But i would like to test our first how heavy the users will be.

Would like to get you expert's view and opinion.

Thank you.
10
Framework Manager / Row level security: need some help/advice
« Last post by Deep750 on 07 Aug 2020 01:43:34 am »
Hi,
We have a row level security implemented that has been working for 10+ years.
We have moved from on prem Cognos and ldap to Cognos on Cloud, with Azure AD.
The method used is parameter map for the security code column in the organization table combined with a session parameter for the user, with the security code for the user, added in a filter for the table. Combining these results in [Organization_table].[SecurityCodeColumn] in {SessionParameter}.

The issue is that Cognos isn't able to save/fetch this session parameter (from Azure AD) when running schedules. This leads all schedules to fail due to corrupt sql, as it isn't able to pass the session parameter value into the query.
We are now looking into solving the row level security in another manner, so that users can use schedules again.

By using the username-session parameter, which Cognos is able to utilize in schedules, we were thinking of using this value to filter another table, with the columns username and security code. Meaning the user security table will only return one row per run. Now my  challenge it to combine the result of the security table into the organization table. How can this be done without joining the two tables? As the security table only will return a single row, I need the value in the security column to be added to the filter of the organization table.

Any advice?


Pages: [1] 2 3 ... 10


       
Twittear