| Author |
 Topic  |
|
|
Bruce
Canada
51 Posts |
 Posted - 06/29/2007 : 08:35:15
|
I am not sure if this something I am doing wrong, if this should be on the wish list forum.
I am using MSAS 2k (I know time to upgrade) and I was trying to using relative date measures with out defining YTD for gross sales, YTD for net sales, etc.
So I followed the article by Bill Pearson III (http://www.databasejournal.com/features/mssql/article.php/3518771) to make relative time measures. Everything works fine in MSAS, and in RP I can use the dimensions with the AddCalulatedMembers in MDX, but I cannot view directly in the field list. I only want to use some of the calulated members and not all of them from the menu.
Thanks
Bruce |
|
|
admin
1645 Posts |
Posted - 06/29/2007 : 11:01:27
|
What is the MDX formula for your calculated measure? Are you adding it to the shared library?
Which menu are you referring to when saying: “I only want to use some of the calculated members and not all of them from the menu.”?
|
 |
|
|
Bruce
Canada
51 Posts |
Posted - 07/03/2007 : 09:07:47
|
Hello Igor
I was creating the calculated MEMBER in MSAS, using the following:
SUM(PeriodstoDate([Time].[Calendar].[Calendar Year]),
([Relative Time].[Relative Time].[Current])).
The twist is that the parent dimension is set to relative time. I also created a bunch of other relative time measures under the parent dimension (year to date prior year, last month etc)
In Report Portal I can see and use the relative date dimension, but cannot see within the filed list menu. If I drag the dimension over the the design area I get all relative measures box with a + sign. IF I click on the + sign all the dimensions pop up fine & seem to have correct data.
I just want to select some of these within a report and not all of them. If they were a normal dimension I could select or un-select them as required.
Thanks
Bruce |
|
|
|
admin
1645 Posts |
Posted - 07/03/2007 : 13:13:20
|
The OLAP Report field list shows measures, dimensions, levels and named sets. It does not show members.
If you created this calculated member under the time dimension you should be able to see it by going to Options > General > Show calculated members. |
|
|
| |
Topic |
|
|
|
Report Portal
Viewing Calculated Members in the field list
