6 Replies Latest reply: May 27, 2016 3:13 AM by Vineeth Thange

I have a list of projects under the head 'Project' out of which some are internal, which need not be included in the project performance graph. How to load only those which are required or eliminate which are not required?

• ###### Re: Partial load of dimension

Create a list of required projects in an Excel file:

From Excel;

Fact:

AllOtherFields

From Source

Where Exists(Req_Projects_ID, Project_ID);

• ###### Re: Partial load of dimension

Awesome Sunny. That worked. However, i still have this question in mind. Cant we write calculated dimension rather than creating another list and calling the field in the chart?

• ###### Re: Partial load of dimension

We can surely do that as well. But if that is something which is not required in your application why bring it in was my thought.

You can always do this using a set analysis:

From Excel;

Fact:

AllOtherFields

From Source;

Assuming Sum(Sales) as your expression, you can do like this -> Sum({<Project_ID = p(Req_Projects_ID)>} Sales)

• ###### Re: Partial load of dimension

Hey sunny. I tried this method and i know something went wrong and whole chart is gone. The challenge here is that, i am summing multiple columns from two different tables. example: Sum of duration + Sum of billable Hours + Sum of non billable hours. So how can i use the second method as you suggested in this scenario?

• ###### Re: Partial load of dimension

So you are saying, this doesn't work?

Sum({<Project_ID = p(Req_Projects_ID)>} duration) + Sum({<Project_ID = p(Req_Projects_ID)>} [billable Hours]) + Sum( {<Project_ID = p(Req_Projects_ID)>}[non billable hours])

Would you be able to share your date model to see what might be causing this?

• ###### Re: Partial load of dimension

Hi Sunny,

Earlier, i wrote the set analysis only to the first portion of the expression. But the way you showed next help a lot. now it worked.

Your help is very much appreciated.

Since i'm learning this, your assistance would really help me to excel my skills. Would you please mind sharing your number?

Cheers,

Vineeth