Scale for x Achsis in Load Script

[kavieweg]

Hi Together,

I have a table loaded from my database and want to Show a Count of a value in a bar Chart. Now i will Change the x achsis dynamically.

Therefore I loaded this:

LOAD * INLINE [

AreaScale3 RegionDrill_ID3

Countries; Country

Regions; Region

Products; Product

] (delimiter is ';')

Country, Region and Product exist in my other table.

Now my Question: How can I link this Values to my other table?

Thanks in advance

Mathias

[kavieweg]

Can somebody help?

[rittermd]

You would link them by the name that you gave the columns in your inline table.  If they match a field in another table then they will associate by default.

[kavieweg]

Thats what I did. But my bar Chart interprets Country, Region, Product as a String and there is no assiciation with the coumns from my other table.

[sasiparupudi1]

Please post a sample of your app

[kavieweg]

[DATA]:

LOAD

[ADR_CITY],

[ADR_COUNTRY_CODE],

[ADR_NAME1],

[ADR_NAME2],

[ADR_NAME3],

[ADR_STREET1],

[ADR_STREET2],

[ADR_ZIPCODE],

[AMOUNT];

SQL SELECT "ADR_ADDITIONAL1",

"ADR_CITY",

"ADR_COUNTRY_CODE",

"ADR_NAME1",

"ADR_NAME2",

"ADR_NAME3",

"ADR_STREET1",

"ADR_STREET2",

"ADR_ZIPCODE",

"AMOUNT",

...

FROM "DB"."TABLE";

Then I do:

LOAD * INLINE [

AreaScale; RegionDIM

Name;ADR_NAME1 <<< This must associate with columns from Table DATA

Zipcode; ADR_ZIPCODE

Country; ADR_COUNTRY_CODE

] (delimiter is ';')

Then I create a bar chart and as Dimension I use RegionDIM. The measure sum(AMOUNT) is once grouped by ADR_NAME1, another time by ZIPCode and so on.

I cant use a drill dimension because i want to change the x axis dynamically.