August 8, 2013 at 8:31 am
Why doesnt my named Calculation appear when Im browsing the cube in SSMS but appears when I brows data in VS? I had a cube that I created using the wizard. I deployed it and it looked good. Then I wanted to add a named calculation to the only measure table in the datasource view to calculate the difference between the orderdate and shipdate. I can see this in Visual Studio when I right click the measure in the datasourceview and selec browse data but not after deploying to the server and browsing the cube in SSMS. These columns and the named calculation reside in my fact table.
August 8, 2013 at 8:44 am
From what you describe it sounds like you've added a calculated column to your fact table in the data source view rather than add a calculated measure.
Calculated measures are added via the calculations tab on the cube designer, not the data source view.
If you want to aggregate around the calculation you've done in the data source view then you can add this as a measure to your measure group. Right-click your measure group and select New Measure. You can then add a sum aggregation around the calculated column you've created in your DSV.
Hope that helps.
Thanks,
Simon
August 8, 2013 at 8:45 am
I figured it out. After creating the named calculation in the dsv, I right clicked the dsv and selected "New Measure From Column" and it was added as a measure in the measures window in the dsv. After processing it again the new named calc appeared when I browsed the view in SSMS.
August 8, 2013 at 8:48 am
Cool! I didn't know you could do it from a right-click in the DSV but that's essentially the same thing as I described.
Thanks,
Simon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply