Recent Posts

Pages: [1] 2 3 ... 10
1
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
2
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.
3
Framework Manager / Re: How to change data type in database layer?
« Last post by Invisi on Today at 06:59:52 am »
Anybody?
4
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.
5
Data Modules / Re: Append to data module
« Last post by therese1 on Today at 06:39:33 am »
Do the data types of the join items match?

MF.
Yes they are exactly the same. So not sure I cannot join them.


Sent from my iPhone using Tapatalk
6
Data Modules / Re: Append to data module
« Last post by MFGF on Today at 06:27:39 am »
Thanks MF ... oh man I was think of like a report appending to bottom of previously uploaded file. Sorry thinking wrong way.

K I did this then tried to join there are 60 files of mnth yr with same format but the join didn't seem to work?


Sent from my iPhone using Tapatalk

Do the data types of the join items match?

MF.
7
Data Modules / Re: Append to data module
« Last post by therese1 on Today at 06:22:02 am »
Hi,

Yes - easily. Just open the data module and add a new data source in the pane on the left :)

MF.
Thanks MF ... oh man I was think of like a report appending to bottom of previously uploaded file. Sorry thinking wrong way.

K I did this then tried to join there are 60 files of mnth yr with same format but the join didn't seem to work?


Sent from my iPhone using Tapatalk
8
Data Modules / Re: Append to data module
« Last post by MFGF on Today at 06:16:45 am »
Hi MF,

Sorry for not being clear... newly uploaded Excel file to be added to existing data module


Sent from my iPhone using Tapatalk

Hi,

Yes - easily. Just open the data module and add a new data source in the pane on the left :)

MF.
9
Data Modules / Re: Append to data module
« Last post by therese1 on Today at 06:15:32 am »
Hi,

Can you clarify the question? Do you mean can a newly uploaded Excel file be added to an existing data module, or do you mean you have a data module already including the uploaded Excel file and you want to re-upload the file adding new data?

MF.
Hi MF,

Sorry for not being clear... newly uploaded Excel file to be added to existing data module


Sent from my iPhone using Tapatalk
10
Data Modules / Re: Append to data module
« Last post by MFGF on Today at 06:13:04 am »
Is there any way to append uploaded excel file to a data module?


Sent from my iPhone using Tapatalk

Hi,

Can you clarify the question? Do you mean can a newly uploaded Excel file be added to an existing data module, or do you mean you have a data module already including the uploaded Excel file and you want to re-upload the file adding new data?

MF.
Pages: [1] 2 3 ... 10

       
Twittear