Hidden member causes Excel to throw error

Hi,

I have an AS2000 utility dimension that hold one calculated member and one 'dummy' member for the fact - dimension join. I use it in a virtual cube to achive currency conversion and I implemented the utility dimension to be able to use it with the aggregrate function that Excel uses on multiple filter selections.

I want to prevent this dummy member to appear in my Excel pivot table. I have tried to use the setting 'Hide member if -No name' and it works great when I browse my cube in ASManager but when I browse it Excel 2007 I get a popup message saying something like 'member could not be found...'

Any idea?

Thanks,Christer

It has been some time since I have worked with AS2000 but I think there is a "Visible" property that you can set on your dummy member.

Another way can be to remove the parent for the calculated member in you shell dimension. Only use the dimension without parent member.

HTH

Thomas Ivarsson

|||Another thing to try is to change the default member for this dimension to point to the calculated member.

Hi

Hi
Can anybody tell me what are the possible causes when a client update request to a server fails..
Some of the ones i suppose r
1 Master server down
2 Link Failure
3 Update Request query syntax invalid
Any more.............Login does not exist - permissions issue, database offline/suspect/corruption, locking issues...|||I read your other post about replication concerns - do you have problems now ?|||Hi

thnx a lot sir for responding to my second query...as far as the first is concened i am still facing the same problems...

I understand the concept of master n slave relationship but have certain queries regarding this...

1) In case the master is down i do i configure my sysem so that a present active slave becomes the master or any other way to tackle this situation.How does the clients know about this new server being set as the master .

2)The master is run as a myslq demon . Now the slaves though being servers ..are run as clients of the master server with a definate usernme who has been granted REPLICATION SLAVE PERMISSion set at the master server??

i.e do i run the slaves as mysql -h xxx -u xxxx -p ?? --mysql client ?

3)Is it necessary t take a snapshot of the datadir at the serer , for the first time i set up replication ?/?


Kindly help me out
Thnx
Varun