LastTransactionReport

Discussion & Feedback for Jet Enterprise
ethanbere
Posts: 4
Joined: Thu Sep 01, 2016 11:40 pm

LastTransactionReport

Postby ethanbere » Thu Jan 19, 2017 6:04 am

Hi All
I have a requirement in which I need (Member no.,Member Name,Contact,Last Transaction Date,Transaction Amount)
My 2 tables are Member table,LsRetailSalesTransaction from the Sales Cube.
What technique can I use to return the last transaction date?

Thank you for the help
Attachments
Member_Lasttransaction Date.PNG

User avatar
HPDeskJet
Jet Reports Certified Professional
Posts: 442
Joined: Wed May 26, 2010 3:40 pm

Re: LastTransactionReport

Postby HPDeskJet » Fri Jan 20, 2017 12:16 pm

Hello -

You mention two tables and a specific field.

Since cubes don't have "tables", I'm wondering if you a accessing the data warehouse instead of the cubes. Could that be the case?
-HP
_______________________
Jet 2015 Certified Trainer

ethanbere
Posts: 4
Joined: Thu Sep 01, 2016 11:40 pm

Re: LastTransactionReport

Postby ethanbere » Sat Jan 21, 2017 8:33 am

You are right.The tables are in the DWH but I need to report from the Sales Cube.The Member fields from the Member table in the DWH would be my dimensions. How do I create the Measure that returns the Value of the last transaction in the Sales Cube.

Thank you for responding.

User avatar
HPDeskJet
Jet Reports Certified Professional
Posts: 442
Joined: Wed May 26, 2010 3:40 pm

Re: LastTransactionReport

Postby HPDeskJet » Sun Jan 22, 2017 8:37 pm

Hi -

Keep in mind that, typically, transaction-level details are not stored in the cubes (the cubes are ideal for high-level, decision-making data).

This is true for the standard cube project (like I have). Is it also true of your project, or do you have customization that includes transaction data in your cubes?

It is best to get that level of detail from the DWH.
-HP
_______________________
Jet 2015 Certified Trainer

ethanbere
Posts: 4
Joined: Thu Sep 01, 2016 11:40 pm

Re: LastTransactionReport

Postby ethanbere » Sun Jan 22, 2017 11:38 pm

I agree 100% and thank you. How would I achieve this in the DWH.

Many thanx

User avatar
HPDeskJet
Jet Reports Certified Professional
Posts: 442
Joined: Wed May 26, 2010 3:40 pm

Re: LastTransactionReport

Postby HPDeskJet » Mon Jan 30, 2017 8:29 am

Perhaps something like this?
last-trans.png
last-trans.png (7.67 KiB) Viewed 392 times
-HP
_______________________
Jet 2015 Certified Trainer

ethanbere
Posts: 4
Joined: Thu Sep 01, 2016 11:40 pm

Re: LastTransactionReport

Postby ethanbere » Mon Jan 30, 2017 1:51 pm

Thank you so much...I really appreciate


Return to “How do I?”

Who is online

Users browsing this forum: No registered users and 2 guests