Section Access/Application using a *

[renjithpl]

Hi All,

Below is my section access/application script.

I want NTNAME B to see all the dashboard.

When I use this, i get no data in it.

Why * does not work in this case.

SECTION Access;
LOAD * INLINE [
    ACCESS, NTNAME
    ADMIN, A
    USER, B
    USER, C
];

SECTION Application;
LOAD * INLINE [
    NTNAME, DASHBOARD
    A, sales.qvw
    A, finance.qvw
    B, *
    C, sales.qvw
];

Thanks

Ren

[sinanozdemir]

Hi Renjith,

Try blank instead of *:

LOAD * INLINE [

    NTNAME, DASHBOARD

    A, sales.qvw

    A, finance.qvw

    B

    C, sales.qvw

];

Hope this helps.

[renjithpl]

I have tried using blank, dint work.

[sinanozdemir]

I edited it, don't use comma after B at all.

LOAD * INLINE [

    NTNAME, DASHBOARD

    A, sales.qvw

    A, finance.qvw

    B

    C, sales.qvw

];

[sinanozdemir]

You may also need to use upper letters for the dashboard names as well.

[renjithpl]

tried all, nothing seems to be working

[jonathandienst]

There's no special meaning for * in the Section Application part of the script.

What are you trying to achieve?

Do you want to map B to all 3 file names?

What are you doing with these file names?

Perhaps this is what you need:

Section Application;

T_Dashboards:

LOAD * INLINE [

    NTNAME, DASHBOARD

    A, sales.qvw

    A, finance.qvw

    B, *

    C, sales.qvw

];

Dashboards:

LOAD NTNAME

Resident T_Dashboards

Where DASHBOARD = '*';

Join (Dashboards)

LOAD Distinct DASHBOARD

Resident T_Dashboards

Where DASHBOARD <> '*';

Concatenate (Dashboards)

LOAD NTNAME, DASHBOARD

Resident T_Dashboards

Where DASHBOARD <> '*';

DROP Table T_Dashboards;

[renjithpl]

Hi Jonathan,

My dimension table has the filed "dashboard names" with values sales.qvw, finance.qvw.....

I want user B to view all the values, i thought using * will help. But when I am reducing the data and when USER B opens the document he can only nothing other than "*".

thanks

[Anonymous]

Try:

B, app1

B, app2

B, app3

like this. * does not work like you specified in section access. I had same experience on field level.

[jagan]

HI,

Try like this

SECTION Access;

Security:
LOAD * INLINE [
    ACCESS, NTNAME
    ADMIN, A
    USER, B
    USER, C
];

LEFT JOIN (Security)

LOAD *

INLINE [

    NTNAME, DASHBOARD

    A, sales.qvw

    A, finance.qvw

    B, *

    C, sales.qvw

];

SECTION Application;

App_Data:
LOAD

DISTINCT DASHBOARD

INLINE [
    DASHBOARD
   sales.qvw
    finance.qvw
   sales.qvw
];

Hope this helps you.

Regards,

Jagan.