Transpose process -kind of

weblike

Hi,

Never used graphs in Aware before, but watched the new beautiful kendo graphs and I want to give it a try.

I want to start with something simple, of course simple for some of you.

I have a BO with tableA (image bellow) and I want to create a process which populates a BO like in table B(image bellow):
(headers of the tables are attributes form these BO's)
Any suggestion will be much appreciated.

BenHayat

The first point that comes to mind is the "Currency". In Table B (Or Bo_B), you have 3 STATIC currency Attributes (USD, EUR and GBR).

Q) Are these 3 values (USD, EUR and GBR) static values in Tabla A as well? Another words, users only have these 3 values to select? If yes, then it very simple to do.
If those values in Table A is dynamic , then it gets more difficult to do when you have STATIC attributes in Table B.

Secondly, you should have your Table A sorted by:
Date
Currency
When looping through.

weblike

Attributes in table A are static.

BenHayat

weblike wrote
Attributes in table A are static.

I was asking if the "Values" in Currency Attribute is STATIC and not the Attributes in Table A.

weblike

Yes they are static. Sorry for confusion.

johntalbott

Is the only purpose of BO B to populate your chart? If so, there are other approaches to consider.

weblike

yes the only purpose

johntalbott

I suggest using SQL to create your query code or a stored procedure that you call from the query. Then you can avoid creating a BO that really does nothing.

Are you familiar with SQL?

weblike

Hi John,

Yes I'm familiar with SQL, but tried to avoid that.

thx,

tford

You can easily set up a self maintaining BOs with rules.

1) Rule for Table A:
..... a) check to see if a value exists in Table B for a particular date
..... b) add an instance in Table B if one does not exist

2) Rules for Table B:
..... a) FIND record in Table A with EUR value for this date & update into Table B EUR attribute
..... b) FIND record in Table A with USD value for this date & update into Table B USD attribute
..... c) FIND record in Table A with GBP value for this date & update into Table B USD attribute

With rules like this Table B will always be up to date.