section access

[QSense]

Hi ,

I have a problem with section access Im doing with this excel file

In excel file ,in groups section,

Group	MUHASEBE	GELIR YONETIMI	URETIM PLANLAMA	REZERVASYON
All	1	1	1	1
Group1	1	0	0	0
Group2	1	1	1	0

there are tab names such as MUHASEBE,GELIR YONETIMI..

and group name

and in other sheet(Section access) there are information below

USER	NTD_EBI\S_SAGLAM	All
USER	NTD_EBI\M_HAPCIOGLU	Group1
USER	NTD_EBI\A_METIN2	All
USER	NTD_EBI\A_KONAR	Group1

this method unfortunately does not work

My script below.

Group: //Exceldeki Section Access sayfasından kullanıcı ve grupları yüklüyoruz.

LOAD NTNAME as User,

[GROUP] as Group

FROM

CARGO_Yetkilendirme.xlsx

(ooxml, embedded labels, table is [Section Access]);

left join(Group)//Exceldeki Section Access sayfasındaki grubu left join ile aşağıdaki Group sayfasına bağlıyoruz.

LOAD [GROUP],

[MUHASEBE],

[GELIR YONETIMI],

[URETIM PLANLAMA],

[REZERVASYON],

[REKLAM],

[YURT DISI PAZARLAMA],

[TURKIYE PAZARLAMA],

[AMERIKA],

[ASYA & UZAKDOGU],

[DOGU AVRUPA VE RUSYA],

[ORTA & GUNEY AVRUPA],

[ORTADOGU & AFRIKA],

[HANDLING SOZLESMELER],

[OPERASYON KONTROL],

[LOJISTIK, IC HAT & POSTA],

[ISTANBUL],

[IZMIR],

[ANKARA],

[ADANA],

[ANTALYA],

[NOBETCI MD. - A EKIBI],

[NOBETCI MD. - B EKIBI],

[NOBETCI MD. - C EKIBI],

[NOBETCI MD. - D EKIBI]

FROM

CARGO_Yetkilendirme.xlsx

(ooxml, embedded labels, table is Groups);

Section Access;//Bu komut ile yetkilendirme kodunun başlatıyoruz.

LOAD [ACCESS],

NTNAME,

[GROUP]

FROM

CARGO_Yetkilendirme.xlsx

(ooxml, embedded labels, table is [Section Access]); //Exceldeki Section Access listesini yüklüyoruz.

Section Application; //Bu komut ile yetkilendirme kodunun tüm dökümanda kullanılmasını sağlıyoruz.

Helps?

[#2]

helle

Try use uppercase for your group

[QSense]

hi

It didnt work

[jjfabian]

Hi,

both your section acces table and your data with which you associate your section access should be in uppercase.

So, for both try upper(Group) as Group.

[#5]

ACCESS  NTNAME GROUP

USER

NTD_EBI\S_SAGLAM

ALL

GROUP	MUHASEBE	GELIR YONETIMI	URETIM PLANLAMA	REZERVASYON
ALL	Y	Y	Y	Y

and go document properties\Opening\

select Initial data reduction  based on section acces

[QSense]

ACCESS	NTNAME	GROUP
ADMIN	ISTEBIQV3\QV_USER	ALL
ADMIN	NTD_EBI\O_ATES	ALL
USER	NTD_EBI\R_CAN	ALL
USER	NTD_EBI\I_EMUL	ALL
USER	NTD_EBI\C_DEGIRMENCI	ALL

GROUP	MUHASEBE	GELIR YONETIMI	URETIM PLANLAMA
ALL	1	1	1
GROUP1	1	0	0
GROUP2	1	1	1

as you see both of them are uppercase

[QSense]

hi syukyoZHU

Unfortunately it didint work

[#8]

i have un example, you can modifly this for you application

SECTION Access;

LOAD * INLINE [

ACCESS, USERID,PASSWORD, TYPETABLEAU,

ADMIN,  ADMIN,ADMIN, *

USER, DIRECTION, DIRECTION, DIRECTION

USER, ANALYSE, ANALYSE, ANALYSE

USER, RAPPORT, RAPPORT, RAPPORT

];

SECTION Application;

star is *;

TypeTablaux:

LOAD * INLINE [

    TYPETABLEAU, VALEUR

    DIRECTION, D

    ANALYSE, A

    RAPPORT, R

    TOUS, T

];

and

it should work

[QSense]

I have attached my files.

Does anybody have an idea?

[#10]

I can't open your document Qlikview