Not sure about the best way to describe this, but;
End goal: find the percentage Revenue for each Market of the total revenue for the company; 100*(Market Revenue)/(Company Revenue)

I have several HOLD files going down to, and joined at the Market Grain.
I have a separate component finding Revenue at the Company level. I can't display the Market Grained Key without the revenue being broken down by market (I think this is a cube oddity). Without the Key I can't join it to the Market Grain holds.

So is there any way I can store Company Revenue in an &var? Be it a field, from Total, or in DM? other work-arounds?


Thanks!

This message has been edited. Last edited by: Nicholas Spyrison,

With something similar to this you can extract the company revenue

TABLE FILE CAR
SUM DEALER_COST AS 'REVENUE'
ON TABLE HOLD AS HLD FORMAT BINARY
END
-RUN
-READFILE HLD
-RUN
-TYPE REVENUE: &REVENUE

Perform on your own Revenue at the Company level file.

quote:

TABLE FILE CAR
SUM DEALER_COST AS 'REVENUE'
ON TABLE HOLD AS HLD FORMAT BINARY
END
-RUN
-READFILE HLD
-RUN
-TYPE REVENUE: &REVENUE

But then it just parameter prompts for &REVENUE
shouldn't we have to -SET &REVENUE?

maybe something like the follwoing?

-RUN
-READFILE HLD
-RUN
-SET &REVENUE = <REVENUE;
-TYPE REVENUE: &REVENUE 

or is there something I am missing?
I am using an alpha hold file.

Add a -DEFAULTH for &REVENUE, this will stop the prompting

Wouldn't that defeat the point? I am trying to store &REVENUE dynamically, not default it to a value.

My assumption is that the fex exists in MRE and when the code is executed, it is scanned for & variables.
If there is no -SET or -DEFAULT(S|H) before the variable it will be prompted.

Adding the -DEFAULTH before(Actually, probably anywhere) the -READFILE will fix this.

I feel like my knowledge is lacking...

Is the -READFILE HLD just going to push <|var into &var then?

I'll try mocking something simpler up in CAR tomorrow. My fex is getting too busy.

Wait till you have a fex that is over 13k lines...

Nicholas,

A -DEFAULT(H) will provide a value for the variable if it is not -SET within your process.

A -READ, -SET or -READFILE will override any -DEFAULT that you have previous applied.

As has been mentioned a few times on the Forum recently, -DEFAULTH will be "ignored" by parameter prompting.

T

Try this. You need to read in the var name.

TABLE FILE JACK1
WHERE LISTIT EQ &HOW_MANY;
WRITE CUM_TA_SHR
ON TABLE HOLD AS 'JEFFX' FORMAT ALPHA
END

-RUN
-READ JEFFX &POT.A6.
-RUN

J.L., you method is also good, but you have to be aware of the field format.

Using READFILE all hold field become a variable, you don't mind the format and the variable has the field name as its &var name.

Both method is good. With READFILE you also don't mind about order of fields when you reference them and you can have 4 fields in the hold file but only reference the first and third one, per example. With READ it's important to READ all the &var in the same order/format as they have been hold.

quote:

Wait till you have a fex that is over 13k lines...

App studio struggles (or crashes) switching between components of a 250 line, 12 component fex with our set up. How does everyone else manage? tweaking tomcat sever allocation?


I digress...

I have the following working. Note that SET ASNAMES=ON is important here. I will relay this attempt back to my original fex.

SET ASNAMES = ON
TABLE FILE IBISAMP/CAR
SUM
     DEALER_COST AS 'REVENUE'
ON TABLE NOTOTAL
ON TABLE HOLD AS HLD FORMAT BINARY
END
-RUN
-DEFAULTH &REVENUE = 0
-READFILE HLD
-RUN
-TYPE REVENUE: &REVENUE

OK have it working as expected. Thanks everyone!

I am sure Waz uses a 13k lines fex to do a complex ETL with a lot of MATCHES, JOINS, DEFINES, MODIFYs and etc.

He also should use any text editor to edit those 13k fex under approot. Am i right?

In this case yes all done in a text editor, GUI could not handle the code. The code was in the APP path, but this fex (Actually group of fexes) produced statements and I would confidently state that is may be the most complex fex ever done. Certainly in the top 10.

[ Waits for head swelling to subside ]

Ok so

quote:

A -DEFAULT(H) will provide a value for the variable if it is not -SET within your process.

A -READ, -SET or -READFILE will override any -DEFAULT that you have previous applied.

As has been mentioned a few times on the Forum recently, -DEFAULTH will be "ignored" by parameter prompting.

Given this; if I have < -DEFAULTH &FM=' ' > then the variable &FM has some value, however, if I have < -DEFAULTH &WFFMT = 'HTML' > then my variable &WFFMT contains 'HTML'. In either case I won't be prompted for the values of these variable; is that right?

I know this is such a newbie question, but I'm getting there. slowly

Also

-READFILE RPTPERIOD tells me that the fields in RPTPERIOD can be used as variables in any order as long as they are in the same format; is that correct?

Thanks for any clarification you can offer!

Pondog

quote:

Given this; if I have < -DEFAULTH &FM=' ' > then the variable &FM has some value, however, if I have < -DEFAULTH &WFFMT = 'HTML' > then my variable &WFFMT contains 'HTML'. In either case I won't be prompted for the values of these variable; is that right?

Correct. As long as &FM and &WFFMT don't receive any other value as input parameter from another fex or HTML page they will keep the DEFAULTH value and you won't be prompted to provide values.

quote:

Also-READFILE RPTPERIOD tells me that the fields in RPTPERIOD can be used as variables in any order as long as they are in the same format; is that correct?

Correct. But if there are 4 fields in RPTPERIOD, they don't need to be all in same format. You can have 3 alphanumeric and 1 numeric field. READFILE will assign the proper format to each as they are in the TABLE FILE.

Outstanding! Thanks a bunch, MartinY