Hi Peter,

I suggest you have a 'Member status' dimension. you can always get the answer for 'number of people logged in to the system in August 2007' but selecting both...

You can have common dimensions like Time and Product. In the 'dimension usage' option in the cube, you should link the dimension keys with corresponding foreign keys in the fact...

Hi,

Have 2 fact tables, and create 2 measure groups in your cube - one for Sales and the other one for Budget.. that is a solid design with more flexibility...

Hi,

When you load the fact table, can't you filter out those records which should not be aggregated? Updating the fact table or joining with another table to check some conditions...

Hi,

Could you explain what you are doing with that 2nd fact table? I am not sure if I got it correctly - why should you have a flag to indicate...

Hi Vijay,

ProClarity is part of the PerformancePoint server now, the new BI suite from Microsoft. See if there is a possibility of moving to that product.

Other BI tool vendors include...

Hi Vijay,

Not often you get a BI 'team' of 1. 🙂 From what I understood, you are doing a intranet project that tracks the employees (login and logout) timings and...

Well, if it's not in production yet, why don't you consider using a view?

Oops, just noticed that you wanted a solution without updating the fact table! 😛

hmm.. but why? if it's a current production environment and you do not want to disturb it,...

Hi,

When you load the fact table, you can calculate this 'duration' and store it. You can use this duration as a measure in your cube.

Let me know if I am...

Hi Karthik,

Do you have this problem only with a particular person? If yes, talk to your team mates to see if they have similar problem with him. You can bring...

Create a job and schedule it. you need run the sql agent up and running..

Hi,

When you create a linked server, you would have given the credentials there itself..

Regards..

Vijay.

You are right, BO will not allow the level name changes. But, what I meant was, in the BO reports, you should be able to differentiate these 2 dimensions clearly...

Hi,

I think, you can change the level name only at the dimension hierarchy level and not at the cube - dimension usage level. By the way, which reporting tool you...