Can user access some data in one sheet which access is rejected in other sheets?

[#1]

hi,

I want to use section access to do this. But if use data reduction, all sheets' data is reduced. Can I control this separately.?

[#2]

For example, in sheet1 , I want user access data of year=2008,2009 . And in sheet2 I want user access data of year=2010(2008,2009 is denied)

[#3]

Hello,

I dont know if I understood your actual requirement, however you may do a Sheet Properties and then add a action to trigger Clear All, On Sheet Activate, so that when you go to sheet 2 all the data is cleared and then select Year again.

Or you can also try creating another Year field CopyYear and then In sheet one use Year and then in Sheet 2 use CopyYear and then have a value 2008 selected in Sheet2 always...However be careful with other things then.. You might have to change the dimensions on other charts as well for Sheet 2.

ANDY

[#4]

Hi,

In your second idea, if I create another Year field COPYYEAR, then old year field will relate COPYYEAR. If I select a year2008 in one sheet, the other field COPYYEAR will be selected because of the relation.

[suniljain]

you can use set analysis in this case

you can avoid year 2010 in first sheet set analysis expression and you can avoid 2008,2009 in second sheet in set analysis expression .

if you require more details , reply me.

I

[#6]

Hi,

set analysis, cannot solve my problem.

I want different user access different data in different sheets.like:

John can access 2008 and 2009 data in sheet1, and 2006~2009's data in sheet2. .....

user	sheet1	sheet2
John	2008/2009	2006/2007/2008/2009
Tom	2006/2007	2008
ABC	2008/2009	2006

Use section access I can do this:

user	sheet1	sheet2
John'	2006/2007/2008/2009	2006/2007/2008/2009
Tom	2006/2007	2006/2007
ABC	2006	2006

[suniljain]

If this is the case then set analysis will not work.

[#8]

Hi,
You can maybe try a combination of section access and set analysis. By adding a table that will link users, years, and sheets you will be able to do it :

Section Access;
users:
LOAD * INLINE [
ACCESS, USERID
admin, ADMIN
user, JOHN
user, TOM
user, ABC
];
Section Application;

data:
LOAD year,
data
FROM
C:\Work\Tmp\nada.txt
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

restriction:
load * inline [
sheetName, USERID, year
Document\SH02, JOHN, 2008
Document\SH02, JOHN, 2009
Document\SH03, JOHN, 2006
Document\SH03, JOHN, 2007
Document\SH03, JOHN, 2008
Document\SH03, JOHN, 2009
Document\SH02, TOM, 2006
Document\SH02, TOM, 2007
Document\SH03, TOM, 2008
Document\SH02, ABC, 2008
Document\SH02, ABC, 2009
Document\SH03, ABC, 2006
];

You can now use a set analysis like sum({$<sheetName={$(=GetActiveSheetId())}>}data).

Hope this helps,

[#9]

RenaudCharlet wrote:
Hi,
You can maybe try a combination of section access and set analysis. By adding a table that will link users, years, and sheets you will be able to do it :
You can now use a set analysis like sum({tiny_mce_markerlt;sheetName={$(=GetActiveSheetId())}>}data).
Hope this helps,
 <div></div>

Hi, this is a good idea. And I test it OK.

I have about 30 charts in each sheet. (10 sheets total). Use set analysis, I have to re-edit hundreds of chart objects .[:'(]

Is there any simpler idea? Thank you.

[maneshkhottcpl]

Hi,

The trick given by above post is very good. If u have many users and need to controll the access u can create the Table (Matrix) in excel sheet instead of inline table.