Recent Posts

Pages: [1] 2 3 ... 10
Cognos Administration / New to Cognos BI
« Last post by Newtocogno on Today at 12:08:37 am »
Hi Everyone,

I am new to the Cognos BI and want to learn it from scratch. Could someone help me where i can download Cognos business intelligence 10.2.2 for my linux lab environment.

Thanks in advance.

Framework Manager / Re: Calculated Time Periods using DMR Time Dimension
« Last post by CognosPaul on 20 Oct 2017 02:32:21 pm »
it certainly looks right.

What happens if you do parent([presentation].[Current_Day_BOD]) instead of [presentation].[Current_Week_BOD]? If you put in the mun directly into the data item?
Report Studio / Re: How to have 'top' without rank
« Last post by venkat01 on 20 Oct 2017 01:48:14 pm »
sorting on descending order to the measure column and do running-count(measure col or any col that you want) then drag this into filter running-count<=10 should get 10.

Sent from my GT-N8000 using Tapatalk

Report Studio / Re: UNIQUE function and MUNs
« Last post by venkat01 on 20 Oct 2017 01:36:20 pm »
My guess is to try Auto grouping yes property of the query

Sent from my GT-N8000 using Tapatalk

Report Studio / Trying to get the length of a date field
« Last post by cognosdelaware on 20 Oct 2017 01:16:10 pm »
I have a date field and I need to check if it is 5 characters and if so format it as YYYYYMMDD

Some of the dates are stored as 5 characters(i.e. 70201 (represents 20070201)) or 6 characters(i.e. 150201(represents 20150201)

How can I convert the date so I can check the length of it for 5 characters?

Reporting / Re: Hide Header in Cognos 11.0.5
« Last post by parkh2 on 20 Oct 2017 12:58:03 pm »
Does anyone know how to make drill through reports to hide the appbar and navbar as well? I am able to hide the appbar/navbar when accessing the main report using the url parameters, but drill throughs don't have this option.
... but running in Cognos 11 Analytics.

Reports, Sourced from a Data Module, when Placed in a Cognos Workspace Dashboard … do NOT allow Drill Through.

Will Drill Through when run from a Cognos Report NOT on a Dashboard.

Has anyone else encountered this?

TIA, Bob
Cognos Administration / Re: Issues with audit data base
« Last post by misscognos on 20 Oct 2017 10:07:52 am »
Any errors in the logs after the job starts? Ie. If you are in a fully working state, then you run the job to "break it", what do you see in the cogserver.log?
Report Studio / Difference between two dataitem of two different query
« Last post by lahdeb on 20 Oct 2017 07:53:14 am »
Hi community ,
I will try to explain my need , and problems I m facing :
Actualy I want to calculate the difference between the nombre of rows of some tables , but the problem is that these  tables exists in two different database (for two different server :/)

For example : Tables A1,A2 from DB A ,
                     Tables B1,B2 from DB B,
I want to have a result which contains :
- Nbrows(A1) , Nbrows(A2) , NumbRows(B1) , NbRows(B2), NbRows(A1)-NbRows(B1),NbRows(A2)-Nbrows(B2)

Solution :
I m using the direct sql since I don't have a package that contains these informations , so what I did is :

select count(*) NbA1
 from A1 where date>=_add_days((getdate(),-5)
select count(*) NbA2
from A2 where date>=_add_days((getdate(),-5)

select count(*) NbB1 from B1 where date>=_add_days((getdate(),-5)
Union select count(*) NbB2 from B2 where date>=_add_days((getdate(),-5)

and I created two requete : 1-with dataitems NbA1 (which contains two rows : NbA1 et NbA2)
                                         2- with dataitems NbB1 ((which contains two rows : NbB1 et NbB2)

so I could create my liste 

------    A     ------    B    -------------   A-B  -----
         NbA1            NbB1                     ?
         NbA2            NbB2                     ?

but I don t know how to calculate the difference A-B :/, is there a way to do difference between two liste , or to identify a colonne of liste ?

Any idea please

Thank you

Pages: [1] 2 3 ... 10