cant access invisible dimension(urgent). still couldnt find the answer

i am trying to access invisible dimension in the reporting services surface. but it is giving error. is there any way to access invisible dimension in the reporting services surface. but this hidden dimension can access in the sql 2005 management server. but in the reporting services cant. pls tel m some way to do that.
pls give me the solution if anyone know about this.
|||

You cannot use Hidden Dimensions in SSRS.

But U can create Hidden Calculated Members in Cube, which U R creating in SSRS MDX.

Then use that Calculated Members in Report MDX Query, It will work fine.

Bhudev

|||thx dev

cannot restore a backup database

hi all,

i just learned mssql server and need help form u guys the experts. i made a backup of database but i couldnt restore it into another machine.
the original database name is "employee" and running in mssql 7. the target database is named "employee" as well and running in mssql 2000.
it gave me this message:

Microsoft SQL-DMO (ODBC SQLState: 42000)

Cannot find file ID 2 on the device 'C:\db_bak\employee.dat'.
RESTORE DATABASE is terminating abnormally.

i tried to restore it to another mssql 7 but it gave me the same error message. i dont know how to fix it. in the sql server log, nothing refers to the restore activity. please help...

thanx in advance,

tonjawin mssql2000 i faced a similar problem.

but the problem was solved when i gave the correct path name for the data and log file.(installation directory\data path)