Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if i want to use section access to reduce data for a field
that field name must be in upper case (and not even a space between?)
so how about if the field in my data model does not fulfill the condition (e.g. CompanyCode)?
is there no way to perform section access but only changing the field name to capital letters (COMPANYCODE)?
Thanks
==================================================
e.g. (from this community)
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, REGION
ADMIN, ADMIN, ADMIN,
USER, USER1, U1, AFRICA
USER, USER2, U2, AMERICA
USER, USER3, U3, ASIA
USER, USER4, U4, EUROPE
USER, USER5, U4, AMERICA
USER, USER5, U5, *
];
Section Application;
SALES:
LOAD * INLINE [
REGION, PROFIT
AFRICA, 1000
AMERICA, 2000
ASIA, 3000
EUROPE, 4000
OCEANIA, 5000
];
Hi, you dont have to change your dimension name, you can use UPPER() functions to do this
see this example
SECTION ACCESS;
Directory;
LOAD ACCESS,
NTNAME,
GROUP,
UPPER([DIVISION Id]) as [DIVISION ID]
FROM
USER.xlsx
(ooxml, embedded labels, table is Sheet1);
SECTION APPLICATION;
Directory;
LOAD
GROUP,
SHEET1,
SHEET2
FROM
SHEET.xlsx
(ooxml, embedded labels, table is Sheet1);
[Division Table]:
LOAD * INLINE [
DIVISION ID, description, Employee
01, bird, fernandoperez
01, bird2, fernandoperez
02, food, marcosaguirre
];
hope this helps
Fernando
hi Fernando
sorry i get confused now, for the capital letter issue
are we going to change the column header or column cell values as capital letters?
i think the upper function in bold letters is only converting column cell values as capital letters
so in your example, the [Division Table] will be the fact table right?
can you explain briefly the fields in section application? thanks