Step 1:
Select cube name and go to measures under cube structure tab as shown in bellow
Step 2:
Right click on cube and select properties
Step 3:
Properties window looks like bellow
Step 4:
Select required field under DefaultMeasure section
Exception deserializing the package "The process cannot access the file because it is being used by another process."
TITLE: Microsoft Visual Studio ------------------------------ Failed to start project ------------------------------ ADDITIONAL INFORMATION: Exception deserializing the package "The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process.". (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ While running SSIS package i got the error “The process cannot access the file ‘*.ispac’ because it is being used by another process”. I tried to close SSDT and run it again but, I still got the same error while compiling. Then, after searching over internet, I got...
The information you shared was useful. Thank you for taking the time to organize it.
ReplyDeleteThank you for your valuable feedback
DeleteReally good information to show through this blog. I really appreciate you for all the valuable information that you are providing us through your blog.
ReplyDeleteThanks for your feedback
DeleteThanks for your feedback
ReplyDeleteThanks that really help
ReplyDeleteThanks for your feedback
Delete