Quote from: khanna100 on 07 Nov 2024 10:01:29 AMAfter you retire, is somebody else taking over?

I will still be around on the forum - posting on here is not part of my day job, nor something I do in any official capacity. I'm just here to try to help others by sharing knowledge, and I hope to continue that :-)

Cheers!

MF.

After you retire, is somebody else taking over?

Do we have some upcoming Cognos Analytics User Groups?

If you do, please share them here or maybe you want to start one up in your region and gauge the interest? 

Hi Mark,

Our reports are being created from FM model package.

Can you please let us know how can we set decimal precision on FM package and report.

Thanks,
Lokeswara

Hi Everyone,

We are getting "PDS-PPE-0104 A record was rejected. An arithmetic overflow occurred. -1,379,278,883 DMB-ECB-0070 PPDS Error." for one of our cognos report.

We found that setting the decimal precision to a lower number might resolve this issue.

Can anyone please let us know how to set this decimal precision to lower number. whether it can done on cognos report, package ?

Thanks,
Lokeswara

Thank you, works well!

Quote from: MatusM on 04 Nov 2024 03:45:41 AMHi,

my data looks like:

Account	Item	Balance
Alpha	Item A1	500
Alpha	Item A2	800
Alpha	Item A3	1200
Beta	Item B1	900
Beta	Item B2	1500
Gama	Item G1	100
Gama	Item G2	200
Gama	Item G3	200
Gama	Item G4	200

In Cognos (12.0.3) report crosstab, I need to categorize Accounts into:
- Top Accounts with total Balance > 1000 per Account
vs
- Long Tail with lower Balance.

I'm doing this by calculated field:

Category

Code Select Expand

if ([Balance] >= 1000)
then ('Top Account')
else ('Long Tail')

But I'm not able to instruct Cognos to summarize Items first, just then categorize the Accounts.
So the result is:

Account	Item	Balance	Category
Alpha	Item A1	500	Long Tail
Alpha	Item A2	800	Long Tail
Alpha	Item A3	1200	Top Account
Beta	Item B1	900	Long Tail
Beta	Item B2	1500	Top Account
Gama	Item G1	100	Long Tail
Gama	Item G2	200	Long Tail
Gama	Item G3	200	Long Tail
Gama	Item G4	200	Long Tail

But outcome I need is this:

Account	Item	Balance	Category
Alpha	Item A1	500	Top Account
Alpha	Item A2	800	Top Account
Alpha	Item A3	1200	Top Account
Beta	Item B1	900	Top Account
Beta	Item B2	1500	Top Account
Gama	Item G1	100	Long Tail
Gama	Item G2	200	Long Tail
Gama	Item G3	200	Long Tail
Gama	Item G4	200	Long Tail

How do I achieve it, please?
Thank you!

Hi,

You can specify in the expression that you want to use the summary balance for each account, rather than the individual balance for each item. So your expression would be:

if (total([Balance] for [Account]) >= 1000)
then ('Top Account')
else ('Long Tail')

Cheers!

MF.

Hi,

my data looks like:

Account	Item	Balance
Alpha	Item A1	500
Alpha	Item A2	800
Alpha	Item A3	1200
Beta	Item B1	900
Beta	Item B2	1500
Gama	Item G1	100
Gama	Item G2	200
Gama	Item G3	200
Gama	Item G4	200

In Cognos (12.0.3) report crosstab, I need to categorize Accounts into:
- Top Accounts with total Balance > 1000 per Account
vs
- Long Tail with lower Balance.

I'm doing this by calculated field:

Category
if ([Balance] >= 1000)
then ('Top Account')
else ('Long Tail')

But I'm not able to instruct Cognos to summarize Items first, just then categorize the Accounts.
So the result is:

Account	Item	Balance	Category
Alpha	Item A1	500	Long Tail
Alpha	Item A2	800	Long Tail
Alpha	Item A3	1200	Top Account
Beta	Item B1	900	Long Tail
Beta	Item B2	1500	Top Account
Gama	Item G1	100	Long Tail
Gama	Item G2	200	Long Tail
Gama	Item G3	200	Long Tail
Gama	Item G4	200	Long Tail

But outcome I need is this:

Account	Item	Balance	Category
Alpha	Item A1	500	Top Account
Alpha	Item A2	800	Top Account
Alpha	Item A3	1200	Top Account
Beta	Item B1	900	Top Account
Beta	Item B2	1500	Top Account
Gama	Item G1	100	Long Tail
Gama	Item G2	200	Long Tail
Gama	Item G3	200	Long Tail
Gama	Item G4	200	Long Tail

How do I achieve it, please?
Thank you!

Hi,

Thank you for the feedback, yes we are using the COGIPF_ACTIONS table but it doesn't provide details on what data have been retrieved (which query have been run), as for Cognos Extended Audit it's more of an inventory tool tried to find some relevant documentation only found this one :
https://developer.ibm.com/tutorials/ibm-cognos-11-audit-extension/

If you have any other information please share.

Thank you

Thank you for the reply, what I mean is we want take advantage of the dataset caching performance, so once we create our data module we generally create a dataset from it. But it doesn't apply the cache to the navigation paths we define.