Recent Posts

Pages: [1] 2 3 ... 10
1
Gurus,

I have a report that I need add logic to break it down more to the code level for some calculations. Code is added to the query of the report, but it's not in the report layout. However, the report is still break down to the code level.

Right now I'm seeing:

ID,    gross wages,  retirement,  benefits,  totals   
1          1500           0                0             1500
1          0                20              0              20
1          0               0                 100          100

I want to show below instead:

ID,    gross wages,  retirement,  benefits,  totals
1          1500           20                100             1620

Please let me know what may have caused the issue.

Thanks,
MB

Hi,

Have you tried changing the calculations to be maximum([gross wages calc] for [ID])

and the same for the others?

Cheers!

MF.
2
Report Studio / Re: Split a column to two columns
« Last post by marzbuzz on Today at 09:55:55 am »
Thanks Paul.. The requirement has changed and this is not an issue now.

MB
3
Gurus,

I have a report that I need add logic to break it down more to the code level for some calculations. Code is added to the query of the report, but it's not in the report layout. However, the report is still break down to the code level.

Right now I'm seeing:

ID,    gross wages,  retirement,  benefits,  totals   
1          1500           0                0             1500
1          0                20              0              20
1          0               0                 100          100

I want to show below instead:

ID,    gross wages,  retirement,  benefits,  totals
1          1500           20                100             1620

Please let me know what may have caused the issue.

Thanks,
MB

4
Report Studio / Re: How to have 'top' without rank
« Last post by hespora on Today at 09:45:18 am »
on dimensional, I believe the function topcount can be used for that. on relational, I don't see an alternative solution.

Why rule out using rank, though?
5
Report Studio / Re: Report Performance Improvement
« Last post by hespora on Today at 09:40:16 am »
Oh hell yes, but try to even find someone who will listen to that idea in a large concern where you, the guy needing the data, are removed so far from the guys managing the system, both geographically and organizationally, that you've never even met. Reality unfortunately is, it's just not worth the hassle.
6
Hi both,

Many thanks for taking the time to reply, and apologies for the delayed response.

I eventually worked my way through the drivers and came to the same conclusion as junkcrusader and am using RedshiftJDBC41-1.2.1.1001.jar.

Initially I got a time-out error (progress!), but established this was due to my company firewall, which has now been opened.

Unfortunately I'm still not able to connect to Redshift, when I click the test button on the connection nothing happens. Eventually I'll get an internet explorer 'page cannot be displayed' etc. I believe this is to do with AWS not allowing the connection their end, although I would have expected to continue to see the time-out error instead of nothing?

Either way, it's now with AWS to confirm everything is set up their side...


Thanks,

James


7
Report Studio / How to have 'top' without rank
« Last post by lahdeb on Today at 08:11:04 am »
Hi all

I m wondering if there is a way to have top 10 of a data item without using "rank" function ?

for example I want to have the 10 recent shippement for each shipper (top 10 date of shippement)

Thank you
8
Data Modules / Re: Append to data module
« Last post by MFGF on Today at 07:05:26 am »
Yes they are exactly the same. So not sure I cannot join them.


Sent from my iPhone using Tapatalk

Can you explain what exactly happens when you join the new file into the data module?

MF.
9
Framework Manager / Re: How to change data type in database layer?
« Last post by Invisi on Today at 06:59:52 am »
Anybody?
10
Report Studio / Re: Report Performance Improvement
« Last post by Invisi on Today at 06:52:00 am »
The data set in itself is rather small. Just dumping this many rows with Cognos is a lot. This sounds like an intermediate result. For me, either you produce the end result in Cognos, or you don't bother with Cognos and put your analysis tool directly on your data mart, data lake or whatever data structure you have connected to Cognos.
Pages: [1] 2 3 ... 10

       
Twittear