Count of Units * Unit Price

My dsv has two tables (one is used materials another is material price).

My used material dimension has "stock nr" and "count of material" attributes and material price table has "stock nr" and "unit price" attributes.

My goal is to calculate "total price" measure for the cube with count of material * unit price. Not all the materials have price value...

I don't know what to do. Could you recommend something?

- Using integration services instead of analysis service before processing.
- Using an MDX query (I am not good at MDX)
- Using Calculations?

Please help me in detail?

You could also join the 2 tables in the DSV, within a Named Query which returns total price as a computed column, like:

select u.[stock nr], p.[unit price], u.[count of material] * p.[unit price] as [total price]

from [used material] u

join [material price] p

on u.[stock nr] = p.[stock nr]

|||too late but thanks. I've used it

Count of Units * Unit Price

My dsv has two tables (one is used materials another is material price).

My used material dimension has "stock nr" and "count of material" attributes and material price table has "stock nr" and "unit price" attributes.

My goal is to calculate "total price" measure for the cube with count of material * unit price. Not all the materials have price value...

I don't know what to do. Could you recommend something?

- Using integration services instead of analysis service before processing.
- Using an MDX query (I am not good at MDX)
- Using Calculations?

Please help me in detail?

You could also join the 2 tables in the DSV, within a Named Query which returns total price as a computed column, like:

select u.[stock nr], p.[unit price], u.[count of material] * p.[unit price] as [total price]

from [used material] u

join [material price] p

on u.[stock nr] = p.[stock nr]

|||too late but thanks. I've used it

corrupted file error

I think one of my file got corrupted when I tried to clean up my dsv and dimension since I got the following message when try to open the cube:

Errors in the metadata manager. An error occurred when loading the
DimProduct dimension, from the file, '\\?\E:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\Financial.0.db\DimProduct.4.dim.xml'.
Errors in the metadata manager. An error occurred when loading the
RevenueAnalysis cube, from the file, '\\?\E:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\AW.0.db\AW\View.26.cub.xml'.

What is the easy way to fix this, I have the back up copy or xmla script, but it won't allow me to run it. I can not even delete the AS database since I am thinking about restore from my backup

Thanks

Don

MS tech support claims this normally goes away after a full process of the database but I haven't found this to be true.

I had to shut down the SSAS service, delete all files within the data directory of the particular database with the problem, start back up the service, then delete the database via SSMS. After this I just re-deployed from our source control and did a full process.

Hasn't happened since our SP2 upgrade (fingers crossed).

Hope this helps.