Recent Posts

Pages: [1] 2 3 ... 10
1
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?
2
Report Studio / Re: How to have 'top' without rank
« Last post by venkat01 on Today at 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

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

Sent from my GT-N8000 using Tapatalk

4
Report Studio / Trying to get the length of a date field
« Last post by cognosdelaware on Today at 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?

Thanks
5
Reporting / Re: Hide Header in Cognos 11.0.5
« Last post by parkh2 on Today at 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.
6
... 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
7
Cognos Administration / Re: Issues with audit data base
« Last post by misscognos on Today at 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?
8
Report Studio / Difference between two dataitem of two different query
« Last post by lahdeb on Today at 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 :


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

Sql2
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


9
Report Studio / Re: monthly reports
« Last post by lahdeb on Today at 07:25:48 am »
Thank you "ImSteve" for your reply
10
Framework Manager / Re: SCD 2 and Fact Table
« Last post by Sep2013 on Today at 05:18:37 am »
also... no other modelling levels above this. although i was thinking ti create star schema groupings and separate out all star models in namespaces with shorcuts.
For now i have to use a separate query to filter claims for ss 2017-01-01 and then do an inner join to.main query to get
 inner join.

But i thought there could be a better way to design the.model so that i can apply filter in main query instead of separate query .

i used kimballs techniques for modelling.. I somehow feel my model is too normalised and.may be thats why hard to use?
Pages: [1] 2 3 ... 10

       
Twittear