Section Access issue with column names

[Anonymous]

Hi every one my requirement is to implement section access in my dashboard

in my

dashboard there are 2 sheets 1.Orders 2. stock and

2 tables 1.OrdersData  2.StockData

i have same customer in both tables with different column names (ORDERCUSTOMERNAME,StockCustomer Name)

my issue is i unable to apply section access in both sheets

my requirement is when customer logged in it should apply in both sheets

ex: when MICHEL Logged in it show only michel data

like below

issue:

but how could i see  same behavior in stocks sheet(with different column names i don't want to create synthetic key)

Attached Sample Application for reference

swuehl‌stevedark‌adamdavi3s‌

[adamdavi3s]

We can't access your qvw as its got section access on it.

The simplest way is just to add a second column on your section access script for the stockcustomer and populate it with the same data

[Anonymous]

i just updated my qvw file please check adamdavi3s‌

[Miguel_Angel_Baeyens]

Indeed, you can use several columns to reduce data, and if your stock and orders and in a separate table, that is the only way of doing it.

You can also create a fact table where you differentiate stocks from orders and then the section access would likely be simpler.

[adamdavi3s · Accepted solution]

Just do this?

//Section Access;

//LOAD * INLINE [

//    ACCESS, NTNAME, ORDERCUSTOMERNAME,StockCustomer

//    ADMIN, MyDomain\satish,

//    USER, MyDomain\KSTL, "MICHEL", "MICHEL"

// 

//];

//Section Application;

[Peter_Cammaert]

Maybe with SA column names in upper case (actually converted automatically in SA, but anyway) and their counterparts in Section Application too

[adamdavi3s]

haha yes I am lazy and let SA do the work...

[Miguel_Angel_Baeyens]

Couple of notes after opening your file:

There can be only one single section access table. If you need, you can use several columns to reduce by, in your case "ORDERCUSTOMERNAME" and "StockCutomer Name".

The fields names and values must be uppercase in both the section access table and the data model table.

I still think that concatenating both tables into a bigger fact table would simplify further developments a lot.

[Anonymous]

how to handle if customer is not available in data model which is added in section access

requirement : My requirement is don't show any data if customer is not available in data model

ex:

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, STOCKCUSTOMER

    ADMIN, MyDomain\satish,

    USER, MyDomain\KSTL, "MICHEL"

];

Section Application;

StockData:

Load Upper([StockCustomer Name]) as STOCKCUSTOMER,    * Inline [

StockCustomer Name ,Value

Rocky, 434

Mark, 43434

Mark, 232

Mark, 5454

Ruceety,43

baker, 965

baker, 445

];

here MICHEL is not available in data here i don't want to  show all customers data

but now it displaying all data in sheet

swuehl‌adamdavi3s‌stevedark‌

[Peter_Cammaert]

Maybe with a different question, you'ld better start a new discussion.