Recent Posts

Pages: [1] 2 3 ... 10
1
cognostechie's advice leads to...

Code: [Select]
s e l e c t   ( s e l e c t   c . P O L I C I E S   a s   ' * '   f o r   x m l   p a t h ( ' ' ) )   a s   P o l i c i e s
f r o m   c m r e f n o o r d 2   r e f
  i n n e r   j o i n   c m p o l i c i e s   c   o n   c . c m i d   =   r e f . r e f c m i d
w h e r e   r e f . c m i d   =   1 2 3 4     - -   t h e   C M I D   o f   y o u r   f o l d e r

This will give you a Base64 encoded value that you'll need to decode.  Once decoded, the results appear not very tidy, but fairly easy to decode visually.  It will require more processing to present more cleanly.  But while you can get Cognos users (and groups, and roles?) and AD users (with a lookup to CMOBJPROPS33?), I don't see a way to identify the name of an AD security group that is referenced this way in Cognos.  Maybe the GUID-like value in Cognos is an actual value somewhere in AD, but I don't have that expertise.

A solution would be more likely to be supported is to use the Cognos SDK.

Motio PI may also provide this information for you, although I don't have much experience with that product.

MetaManager may also be able to produce this.

I reached out to the site admins and MetaManager is indeed a good solution for this. Hopefully one of the MetaManager gurus will be along to offer some advice shortly.

Cheers!

MF.
2
Reporting / Re: Cognos report to show count for quarters
« Last post by Avi on Today at 06:50:52 am »
Hi

Thanks BigChris.

I achieved this by writing a query at FM.

 SELECT YR,QTR,SUM(COUNT) OVER (ORDER BY YR,QTR) FROM (SELECT YR,QTR,COUNT(TICKET_ID) FROM TAB1 GROUP BY YR_NUM,QTR_NM)


Thanks
3
cognostechie's advice leads to...

Code: [Select]
s e l e c t   ( s e l e c t   c . P O L I C I E S   a s   ' * '   f o r   x m l   p a t h ( ' ' ) )   a s   P o l i c i e s
f r o m   c m r e f n o o r d 2   r e f
  i n n e r   j o i n   c m p o l i c i e s   c   o n   c . c m i d   =   r e f . r e f c m i d
w h e r e   r e f . c m i d   =   1 2 3 4     - -   t h e   C M I D   o f   y o u r   f o l d e r

This will give you a Base64 encoded value that you'll need to decode.  Once decoded, the results appear not very tidy, but fairly easy to decode visually.  It will require more processing to present more cleanly.  But while you can get Cognos users (and groups, and roles?) and AD users (with a lookup to CMOBJPROPS33?), I don't see a way to identify the name of an AD security group that is referenced this way in Cognos.  Maybe the GUID-like value in Cognos is an actual value somewhere in AD, but I don't have that expertise.

A solution would be more likely to be supported is to use the Cognos SDK.

Motio PI may also provide this information for you, although I don't have much experience with that product.

MetaManager may also be able to produce this.

4
Do you have access to the Content Store DB? If yes then you can probably use a SQL to get this info.
5
Administration and Security / Re: Import SSL certificates
« Last post by RiRo on 21 Apr 2021 07:52:21 am »
Thank you for your answer!

Here is my problem, because the documentation presupposes for an external CA to create a CSR.

But in this special case, there was made a CSR in the past and the external authority resend the certificate for the WAS 8.5.
On this WAS 8.5. SSL is successfully enabled.

But now I want to catch that certificate and want to cram it in the keystore of Cognos V11 (Liberty)
I think there are other steps, which should be made, that this works.

Regards
Robert
6
Administration and Security / Re: Import SSL certificates
« Last post by MFGF on 21 Apr 2021 07:19:04 am »
Hello community!

I am forced to run Cognos V11(including Websphere Liberty) in co-existance with a WAS 8.5 server.

The WAS 8.5 has a SSL communication enabled, with a signed certificate from an external CA.

What I want to do is, to run Cognos on a alternative Port e.g. 16317 and import the certificate from WAS 8.5 to the Cognos Websphere Liberty, to have also a SSL communication enabled.

So my question is, how can I import this certificate?
Which certs, keyfiles, passwords do I need from the WAS?

I'm not sure if this is a silly idea or if that is possible  :-\

Thanks for your advice.

Robert

It's not something I have ever done, so I can't give you any first-hand experience here, sorry. A good place to start is with the documentation, though:

https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=options-configuring-ssl-protocol-cognos-analytics-components

Good luck!

MF.
7
Reporting / Re: Cognos report to show count for quarters
« Last post by BigChris on 21 Apr 2021 04:18:24 am »
Ok - that makes things clearer, but not necessarily easier.

I can't think of a clever way of doing this other than a calculation for each field:

2020Q1 =
Code: [Select]
extract(year,[DateTicketOpened]<2020 or (extract(year,[DateTicketOpened] = 2020 and extract(month,[dateTicketOpened]) between 1 and 3)
You might need to play around with sums or counts...
8
Administration and Security / Import SSL certificates
« Last post by RiRo on 21 Apr 2021 02:14:23 am »
Hello community!

I am forced to run Cognos V11(including Websphere Liberty) in co-existance with a WAS 8.5 server.

The WAS 8.5 has a SSL communication enabled, with a signed certificate from an external CA.

What I want to do is, to run Cognos on a alternative Port e.g. 16317 and import the certificate from WAS 8.5 to the Cognos Websphere Liberty, to have also a SSL communication enabled.

So my question is, how can I import this certificate?
Which certs, keyfiles, passwords do I need from the WAS?

I'm not sure if this is a silly idea or if that is possible  :-\

Thanks for your advice.

Robert
9
Reporting / Can you refer to singletons in a data expression?
« Last post by mp3909 on 20 Apr 2021 01:31:18 pm »
Hi,

I wanted to know how to go about referencing singletons?

For example, I have a query called q1.
Inside q1, I have a data items called d1, d2, d3.
And in my report I have singleton s1 and s2

I want to write an expression for d1 so I click on data expression and inside there, I want to write a case when statement like the following:

CASE
WHEN [q1].[d2] = 'X' then s1
WHEN [q1].[d3] = 'Y' then s2
END


Is this possible?

Thanks in advance.
10
Reporting / Re: Add comment to a (saved) Report
« Last post by bi4business on 20 Apr 2021 10:05:29 am »
All,

I heard it was removed within CA 11 .......

Still the property in the Report is there  :o

There is a intergration with SLACK ......
And that's not allowed with my customer, so I need to find another solution.

..... not happy  .....
Pages: [1] 2 3 ... 10