Showing posts with label calculated. Show all posts
Showing posts with label calculated. Show all posts

Sunday, March 11, 2012

Add static calculated column AFTER dynamic columns in a matrix?

Is it possible to add a calculated static column to a matrix, after the
dynamic ones?
I have the following matrix to create:
Indicator Units 2001 2002 2003 2004 %Change
----
Volume M3 23 33 44 55 25%
Energy KJ 33 34 35 36 3%
etc.
The year values come from a dataset and may vary (sometimes only 1 year,
sometimes 5 or 6 years). The last column is not depending on the dataset and
takes the values of the last 2 dynamic columns to calculate the % change.
1) is it possible to add a static column after the dynamic ones?
2) can I refer to the last dynamic column (and the one before) in an
expression?
Thanks,
VincentI am not really sure if you can filter the totals at the
end of the dynamic columns or not , but you can place a
textbox after the matrix and specify the expression as
follows :
=First(Fields!FieldName1.Value) OR =Last(Fields!
FieldName2.Value)
OR you can have a table with just the footer and only one
column and specify the filter expression in this one place
holder in the table.
>--Original Message--
>Is it possible to add a calculated static column to a
matrix, after the
>dynamic ones?
>I have the following matrix to create:
>Indicator Units 2001 2002 2003 2004 %Change
>----
>Volume M3 23 33 44 55 25%
>Energy KJ 33 34 35 36 3%
>etc.
>The year values come from a dataset and may vary
(sometimes only 1 year,
>sometimes 5 or 6 years). The last column is not depending
on the dataset and
>takes the values of the last 2 dynamic columns to
calculate the % change.
>1) is it possible to add a static column after the
dynamic ones?
>2) can I refer to the last dynamic column (and the one
before) in an
>expression?
>Thanks,
>Vincent
>
>.
>

Monday, February 13, 2012

Add a calculated measure to a Measure Group ?

I have created a calculated measure which is logically very much part of a specific measure group but I can't seem to work out how to add it to the measure group.. it just sits there as part of the general Measures.

Can I specifiy in which Measures group it should reside? This would also make more sense for managing Perspectives..

In the calculations tab, when you are defining the calculation, look on the toolbar for a button named "Calculation Properties". Click on that and it will open a dialog box that you can use to add either display folders or associated measure groups for each of your calculated members. Just add an associated measure group for the calculated member in question and it will then show up visually in that measure group's list of items.

HTH,
Dave Fackler

|||Thanks.. not exactly obvious is it!|||

Hi Dave,

how another property of Calculated member "Description" can be set ?

Only with notepad?

|||

Hi,

Here is how to relate the calculated memeber and the measure group

1. Open the calculations tab in the BI studio

2. Select the calculation (you want to set) from the left 'script organizer' window

3. Click on the 'Calculation properties' toolbar button (It is on the calculation tab, above the script organizer)

or from the top BI studio menu, select Cube>Calculation Properties

4. This opens a dialog box, with all your calculations on the left drop down and all the measureGroups on the right drop down. (ignore the display folder)

5. select the calculation from the left drop down and the associated MeasureGroup from the the right drop down.

Its pretty easy, you should be able to do it in a snap

Regards