Report Hardcoded values

[priyarane]

Hi Experts,

I have built the data but now need to put some filters which is not present in the source but still I need to hard code those values.

I am bit confused to put the values(Dummy/Hardcoded values). So please help me where to add dummy data.

For filtes and source data and my app added as attaced. It should work properly in association wise.

[jonathandienst]

You could put the values in variables or with inline loads into fields.

For variables - set in your load script:

     Set vLimit1 = 0.85;

     Set vLimit2 = 1.05;

For in line loading:

     Limits:

     LOAD * Inline [

     Type, Upper, Lower

     A, 0.8, 1.05

     B, 0.95, 1.01

     ];

After reloading, you will be able to use these values in your chart and table expressions.

HTH

Jonathan

[priyarane]

Hi Jonathan,

Thanks for reply,

But how can I get filters then

Ex

Legal Entity

HNAH_CIB

HNAH_CISA

HNAH_SB

HNAH_SA

Line of Business
LOB1
LOB2

Scenario Type
Sce1
Sce2

Reporting Period
11/30/2014
12/30/2014

[ankitaag]

Hi Priya,

How would you liunk those filters to your dashboard?

[priyarane]

Hi Ankita,

Yes these reports are prototype so no data for filtes so I wanted to hard code the values for filtes and I have to show them on dashboard

[ankitaag]

So, you can directly create Inline tables for all the filters and display them in the list box:

LegalEntity:

LOAD * INLINE [

    Legal Entity

    HNAH_CIB

    HNAH_CISA

    HNAH_SB

    HNAH_SA

];

LineOfBusiness:

LOAD * INLINE [

    Line Of Business

    LOB1

    LOB2

];

ScenarioType:

LOAD * INLINE [

    Scenario Type

    Sce1

    Sce2

];

ReportingPeriod:

LOAD * INLINE [

    Reporting Period

    11/30/2014

    12/30/2014

];

[priyarane]

Hi Ankita,

That is correct. But values will not be change if I place those on dashboard.

So I am looking something like, can we add data as source even if it is hard coded.

if nothing is possible then I will do create as you suggested and I will concatenate those.

[ankitaag]

Hi Priya,

That's why I asked you that If you want these hard coded filters then how will you link your source tables.There is no connection between them

So to make the data change you need to add data in your source excel

[priyarane]

Hi Ankita,

I will add it

[ankitaag]

sure