Calculated field with Percent

Hi,

I have a calculated field with percent format. However, the value of this field aggregates at every attribute i place on the browser. i want only to show this calculated field in the detail cell on. if the user tries to roll up, i must not be able to see any data in it.

Example

Problem: (View 1)

Service Job Discount Amount

1 200% 3000

2 40% 500

3 100% 400

As i drag the line number to the browser, i saw the right discount value:

(View 2)

Service Job LineNumber Discount Amount

1 1 100% 1500

1 2 100% 1500

2 1 40% 500

3 1 60% 100

3 1 40% 300

How can I make the discount blank on View 1 and only exists if i drag the line number? The problem in View 1 is it sums up the discount which is wrong.

cherriesh

Check whether you are in the right level:

CASE WHEN
[Dimension].CurrentMember.Level.Ordinal > 0
THEN [Measures].[Discount]
ELSE
NULL
END

More info and better recommendations here:
http://www.mosha.com/msolap/articles/mdxcomparinglevels.htm

Hope that helps,
Ibrahim

Cache Warming

Hi,

I have a cube, which is having a lot of calculated measures.

There are some MDX queries which fetches data from the cube, and aggregates data through a parent -child hierarchy.

It is taking considerable amonut of time.

So , for improving the performance i have written a c# program which executes all the possible MDX queries just after the daily refresh of the cube. As expected it was really giving noticable performnace improvement.

But the problem started when i deployed the cube and the cache warmer into another server, where the cache warmer is executed by Sql Agent, with the service account which is a local admin on that box. The warmer program executed fine, but i am no longer able to find the performance improvement. I understand that , the global cache will be shared across the users only if the users are having same security role in the cube.

So i added the sqlagent service account to the role whiich execute the MDX in the application. But still it is not helping me

Please help me.

Also i would like to know, whether clearing the cache everyday would help in any way in this scenario.

Regards,

Jiju

Somebody please tell me whether I am doing any blunder stuff here, at least

Regards,

Jiju