I have added a new dimension to a database and it is available in the cube however when I try to process the dimension I get the following message
The 'OP-ReferralSource' dimension was not found in the 'NCHC SSAS' database on the server
However in the cube design it is available for selecting on the 'Dimension Usage' tab bu on the next tab is is not in the metadata
in the main cube which has multiple cubes init it is halg there I cannot amend the dimension TAB to select regular as it doesnt associate with a measure group
Please I am new to this stuff could someone helps
Thanks
Caroline