0

LastTransactionReport

Jet Reports Historic Posts

January 19, 2017 13:04

None

Follow

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

• Member_Lasttransaction Date.PNG

• Facebook
• Twitter
• LinkedIn

6 comments

• 0
  
  Jet Reports Historic Posts January 20, 2017 19:16

  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?

• 0
  
  Jet Reports Historic Posts January 21, 2017 15:33

  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.

• 0
  
  Jet Reports Historic Posts January 23, 2017 03:37

  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.

• 0
  
  Jet Reports Historic Posts January 23, 2017 06:38

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

• 0
  
  Jet Reports Historic Posts January 30, 2017 15:29

  Perhaps something like this?
  
  
• 0
  
  Jet Reports Historic Posts January 30, 2017 20:51

  Thank you so much…I really appreciate