Recent Posts

Pages: 1 2 [3] 4 5 ... 10
Best would be to put the member() function in the use value and LATAM North - Mexico as the display.

If you have the [test] data item in your query, you could probably get away with having [test] as the use.

Cognos Administration / Re: Content manager activation time
« Last post by sdf on 16 Aug 2018 11:58:57 am »
hi! thanks for your reply.

But I am not quite sure what process you are pertaining to.
Exactly what I'm looking for is a log where it tells me the time cognos switched content manager.
Cognos Administration / Re: Content manager activation time
« Last post by cognostechie on 16 Aug 2018 11:47:38 am »
The process which you have for switching Content Store from one to another (in case of a failover) will have that time.
Reporting / Distinct first name and last name
« Last post by rwaugh on 16 Aug 2018 10:50:42 am »
Hello Everyone,

I am hoping one of you will be able to help me with my current issue.  I have two queries that I join to obtain my final data set.  Query 1 contains a listing of clients First and Last Names, along with a unique identifier.  Query 2 contains the same unique identifier but also contains alternate first names and alternate last names.  As a result, the JOIN query could contain more than one record for each unique identifier, which is fine.  The issue is that I would like to then take that data and output it so that there is only one record for each unique identifier.  The catch is that I would like the First and Last Name columns to contain UNIQUE names separated by "/".  For example, if John Doe (ID 123456) has several alternate names I only want the unique names to show - ID 123456 has the following First and Last Alternate names:  John Does, John Doesnt, Joe Does, Joe Doesnt, Joe Wants.  So the final output should be the First and Last name from Query 1 followed by the other known names:  John/Joe (for the first name) and Doe/Does/Doesnt/Wants (for the last name).

Any thoughts/ideas?

I tried using repeaters but the repeaters, although working, does not allow me to pull in just the unique names (it would use John/John/Joe/Joe/Joe for example).

Cognos Administration / Content manager activation time
« Last post by sdf on 16 Aug 2018 10:38:26 am »

is it possible to see or check anywhere when a content manager became active?
in a failover scenario, I want to check the time when standby content manager switched to becoming active.
Or time when primary content manger failed.
how do i add the static member .

I have a member created in the query called test  which has the calculation .

When i go to static choices add , it asks for use value and display value .

Use value should it be the member name in the query which is test .
Reporting / coloring a radial graph
« Last post by sukanya on 16 Aug 2018 09:24:17 am »
is it possible to color the radial graph (rave chart) red, yellow and green based on certain thresholds. cognos 11.0.9.

Thanks & Regards,
You can absolutely have both query derived items and static items in a single prompt. Give it a try and see what happens.
Administration and Security / Re: Cognos Analytics 11.0.12 is here
« Last post by nav_shiv on 16 Aug 2018 08:53:48 am »

I asked IBM the question on why there has been no fix list since release 11 and they responded with this:

Unfortunatly it was decided to discontinue the fix list with Release 12.

If you require a status update on an APAR you need to open a Support ticket and ask for the status of this specific APAR.

Bit silly really, these lists are very important to us.
Report Studio / Re: Cognos BI- percent in Cross table- Report studio
« Last post by Um_Cog on 16 Aug 2018 08:49:10 am »
Ah sorry, I thought it was clear.

the cross table gives the right values but it ignores the percent format, shows just double like 0,56 , what I want to display is 56%

thank you
Pages: 1 2 [3] 4 5 ... 10