Hello All,
This is my first post in this group. I'm facing a weird issue with
Security Roles in Analysis Services 2000. I have a simple .Net web
application created which has only one file with the code that is there
in aspadocomplex.asp ( ships default with Analysis Server installation
) and in FoodMart 2000 DataBase Iam referring to Budget Cube. I have
added a Role with access to "Net Expense" and its bottom levels on
Account Dimension.
The MDX that Iam using is "SELECT {[Account].members} ON
rows,{[Time].[1997]} on columns from Budget".
The connection string that Iam using is : Provider=MSOLAP.2;Data
Source=http://<Server IPAddress>;Initial Catalog=FoodMart
2000;Roles=<New Role Created>;

when I run it from web browser I get the following result which is
correct :


1997
All Account
($166,482.44)
Net Income
($166,482.44)
Total Expense
$166,482.44
General & Administration
$22,246.08
Information Systems
$44,713.80
Marketing
$66,860.96
Lease


But when I refresh the page , the result set changes randomly , the
incorrect result set that Iam getting is as follows :


1997
All Account
$398,755.69
Assets
Liabilities
Net Income
$398,755.69
Net Sales
$565,238.13
Gross Sales
$565,238.13
Cost of Goods Sold
Total Expense
$166,482.44
General & Administration
$22,246.08
Information Systems
$44,713.80
Marketing
$66,860.96
Lease
$32,661.60

The above resultset is possible only when the Dimension Access is
unrestricted.So I believe Security may be switching on/off on random
page refreshing.
Iam desperately struck with no solution. Any kind of help is highly
appreciated.

Thanks in Advance.....