Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Newbie To Microstrategy!!Help requested

Newbie To Microstrategy!!Help requested

Newbie To Microstrategy!!Help requested

Hello All,

I'am new to MicroStrategy and got hold off one evaluation copy. I'am trying to do dept productivity report which i dunno how to accomplish in MS.

I have a table which contains details of employees assigned to each project, which may vary time to time, but a employee will be assigned to only one project at a time. How do i get department wise count of employees( employee's latest assignment and not old ones ) assigned to each project. I should get Depts as rows and projects on the column and count of employees in the body. One more thing I should be able to do the report for a given period because the management might look to see the productivity for a given month or as on date.

Many a thanks


RE: Newbie To Microstrategy!!Help requested

1)  sign up for their online seminar called "Installing MicroStrategy 7 Evaluation Edition" at http://www.microstrategy.com

RE: Newbie To Microstrategy!!Help requested

I have installed Microstrategy successfully and even created the projects and some basic reports. Iam looking at a specific report for which i need some assistance.

many a thanks


RE: Newbie To Microstrategy!!Help requested

to find the latest employee assigment, you need to use the method described in the following thread:
Thread395-284278 you need an "ending on hand" employee status.  This means you need to model a time dimension into the employee table.  Something like assigment_date will do.  THen for a given period you create a simple filter with begin and end date.

RE: Newbie To Microstrategy!!Help requested


thanks for your answer. i do have assignment date but i basically use assignment no to find the employees latest assigned project. how will that "ending on hand" logic work here as given in the other thread. how do i get the count of employees on a specified project with that "ending on hand". how to accomplish that?

i'm terribly sorry. i'm new to this tool and if some one could help me i would really appreciate it.

million thanks in advance


RE: Newbie To Microstrategy!!Help requested


can you give a more detailed steps on how to use 'Ending On Hand'. i could not understand the information given in that thread.

thanks a lot.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close