Adding tasks to OLAP cube

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Project
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - MS-Project 2000 error in date for september month Hi We are using ms-project 2000. I'm working an a resources project files. I wanted to set Monday 06 of september 2004 as a vacation day. Surprise !! The september 2004 calender show Monday 08. I tried to find any bugs related to an error concerning calendar date in Microsoft web site and cannot find any. Any comments to resolves this problem will be appreciate. Thank you Tag: Adding tasks to OLAP cube Tag: 69217
  - 2
    - Can't Update Tasks from PWA When I, as project manager, click on Update to update the tasks into Project from PWA, it comes back with red flags in (i) column and red color words on top column of the table saying "Save your project file with this task change". I also can't change the "Accept" column...status there is permantly set to word "Accept" Any help will be highly appreciated. Regards, Mazzz -- Project Management Professional (PMP) Tag: Adding tasks to OLAP cube Tag: 69215
  - 3
    - unlink calendar from estimated hours? How does one unlink the calendar from estimated hours. I am assigning task to be performed with a certain period of realistic time which can be for a greater period of time. A task is estimated to be accomplished within a 3 week period of time. when i put in a start date and ending date of 40 hours and hit enter and then go back and look at teh task the calendar dates have closed up to just a period of 40 hrs. The person working the task has other tasks on other projects to work on and is not expected to work non-stop. Tag: Adding tasks to OLAP cube Tag: 69208
  - 4
    - Outlook Express 6.0 sending to unselected recipient when I use the bcc feature, my message goes out to hundreds of recipients in my Address Book whom I did not select. These are hidden in the background and there is no indication to me. But, my service provider blocks my outgoing emails because it shows that I have sent over 1,000 emails. And, I receive error messages back from people to whom I did not send the message. Tag: Adding tasks to OLAP cube Tag: 69206
  - 5
    - Cost vs. client rates Hello, I am using Enterprise Project Server 2003. We have multiple projects and all the resources base cost is $40 / hr. Each project (about 20 of them) represent different clients. Therefore, each project standard rate (or client rate) is different (rates range from $70 - $150). At the end of the day, our company would like to print off a revenue report (by project or by client). So we would need to use the different rates for each. I am trying to figure out how I can do this when using the 'Enterprise resource pool' where all projects are linked into?? I know there is table rates A-E, but I am kinda confused how it would work, considering 1 resource could be on multiple projects. We would also like to print off a margin report where we compare the base cost to the actual bill out rates. Any feedback or guidance would be appreciated. Mark Tag: Adding tasks to OLAP cube Tag: 69205
  - 6
    - Implementation of Microsoft Project Server 2003 I am a not a developer but sort of a business analyst trying to find some best practices on creating project on Project Server with the goal of being able to manage Dept. resources. Below is a list of questions I currently have based on my limited use of the project: (Is there anyone willing to talk me or give me a brief answer to these questions, I'm taking baby steps). Project Server Questions: How is your Agency using Project Server (Are you tracking all It Resources both inhouse or vendor related Projects? Who acts as Resource Managers How do you track administrative time for non project related meetings and time off. How do you categorize projects (ie, Full Project, Maintenance, Enhancements) If so what is definition of maintenance and enhancements Are maintenance and enhancement projects tracked by fiscal year, calendar year and how much task detail is required. What detail is provide for enhancement/maintenance projects When a vendor is hired to create a new application or modify an application, who manages the Project? How do you account for vendor related activities and internal resource activities? Do you have specific documents or templates staff should use for Project management Where are these documents stored? Within the workspace on the project server within the public documents section, in sharepoint outside of project server or somewhere else? Do you have any lessons learned (what would you do differently) Project Procedures/PMO related Questions: Do you have procedures Do you have a PMO Office What type of staff comprises the PMO Office What are the duties and responsibilities of the PMO Office Who does the PMO Office Report too Do you have any lessons learned (what would you do differently) Tag: Adding tasks to OLAP cube Tag: 69204
  - 7
    - Renamed and relinked file shows old name I am using a master resource pool and creating ad-hoc project files to get a better look at all the projects at one time. I either create the file when I open the resource pool or use the open option from the shared resources dialog. I renamed two projects to better represent the working names of the projects, however the original name shows up as the title of the embeded project. I did break the link and relink the project before renaming the file so the name in the shared resourced summary shows the correct, renamed file. I updated the project properties summary in an effort to correct the issue with no change. The project name is correct in the project field when exported. Where am I missing this change. Thanks in advance for any light you can shed on this problem Tag: Adding tasks to OLAP cube Tag: 69202
  - 8
    - Cannot enter actuals in Web Access Hello, We are trying to implement EPMS and so I have added a project to the project server 2003 (EPMSimplement.mpp). I have been configuring the settings within EPMS. One problem that I am having is that we cannot enter in 'Actuals' in timesheet view. We can only adjust the % complete, and remaining work columns. I have been adjusting the setting within the "Customize Probject Web Access" within the Admin center. I have tried all options, including the 'Managed Periods' option where you open reporting periods. Nothing seems to work with this project. This project file was added to project server when the project was 50% complete. So there are no actuals added for the first half of the tasks. Would this have something to do with my problem? Does anyone have any options that I can try to hopefully resolve? I have added a few other 'dummy' projects, and we can enter 'actuals' to the tasks from these projects. Mark Tag: Adding tasks to OLAP cube Tag: 69201
  - 9
    - Deleting Published projects from Project Server 2003 Hello, I have a project that was published to project server 2003 which I am trying to delete from the server. The problem I have is that I permitting checked out. I cannot check it back in, so that I can delete it because the .mpp file somehow got deleted. In other words, I can only open the published version 'read only'. Does someone know how I can get around this problem? Mark Tag: Adding tasks to OLAP cube Tag: 69200
  - 10
    - Archiving projects in Project Server Has anyone come up with a way of archiving old (completed) projects in Project Server. Specifically we would like to keep all projects (active and completed) in the Project Server database but remove the completed projects from ALL Project Web views... Seems logical.. By exception we would open a few Project web views to access the old projects. Arhh.. You say.. Place filters on the Web Views. Get real that's many, many views and even then you cannot filter out completed projects from the Resource Availability views where we have the most annonying situation of all those old projects (with coloured ledgends) being displayed. Simple request... Some way of retaining the old projects in the database for reference purposes but automatic removal from all Web views once projects are completed. My kingdom for a horse ! Tag: Adding tasks to OLAP cube Tag: 69197
  - 11
    - Convert varchar before adding in the TASK_RTF_NOTES field Hi to all, I would like to insert a varchar string I get from a table in the binary object contained from the TASK_RTF_NOTES field of the MSP_TASKS table. I found this vb sub doing this work but I cannot use it because I use a sql server stored procedure to perform the tranfer. I would like to write the same procedure in T-SQL but I cannot find the statement equivalent to 'StrConv(rtf, vbFromUnicode)' in T-SQL Sub WriteNote(NoteText As String) ' writes RTF data to MSP_TASKS.TASK_RTF_NOTES. Dim cn As New ADODB.Connection Dim cmd As New ADODB.Command Dim param As New ADODB.Parameter Dim sql As String, rtf As String, cnString As String cnString = " ... " sql = "update MSP_TASKS set TASK_RTF_NOTES = ? , TASK_HAS_NOTES = 1 ,EXT_EDIT_REF_DATA = '1' where PROJ_ID = 1 and TASK_UID = 2" rtf="{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fcharset0 Arial;}}" & vbNewLine & "\viewkind4\uc1\pard\f0\fs20" & NoteText & " \par" & vbNewLine & "}" & vbNewLine & vbLf & Chr(0) 'be sure to specify valid RTF text here including "vbLf & Chr(0) cn.Open cnString param.Direction = adParamInput param.Type = adVarBinary param.Size = 8000 param.Value = StrConv(rtf, vbFromUnicode) cmd.ActiveConnection = cn cmd.CommandText = sql cmd.Parameters.Append param cmd.Execute End Sub Thanks in advance, any help will be valued!! Gabriele Tag: Adding tasks to OLAP cube Tag: 69196
  - 12
    - how do i save a date in date picker on a new page of a form Im using microsoft outlook 2000 and have designed a new page on a task form. I have used the Microsoft date & time picker from custom controls for the start and due dates as the dates fields in field chooser dont have the date picker drop down feature. When I enter dates in the date picker and then save and close, and then re-open, none of the dates have saved, however when i use the date fields from field chooser they do save. Does anyone know a way of making these dates save ? Tag: Adding tasks to OLAP cube Tag: 69195
  - 13
    - Change to Project 2003 Resource Availability View At the 11th hour of our Project 2002 to 2003 upgrade we have found a small change to the Project Web 'View Resource Availability" page that has significant implications to our Resource Planning process. In Project 2002 Web we would select multiple resources (usually a team) and use the 'View Resource Availablity" page and "Remaining Availability" view in order to identify overallocated resources... This is quite easy as overallocated resources would display with NEGATIVE Remaining Availaibilty... In Project 2003 this view (graph) NO LONGER SHOWS NEGATIVE Remaining Availability on its "y" axis, negatives are show as zero, therefore no longer showing you over allocated resources.. Am I missing something here... Tag: Adding tasks to OLAP cube Tag: 69194
  - 14
    - distibution list double up When I send an email to a distribution list, it goes twice. The second time it is sent 15 minutes later but does not show up in the sent file. I have tried deleting my list and starting again. Any suggestions? -- Thanks for all help Annie Tag: Adding tasks to OLAP cube Tag: 69191
  - 15
    - Resolving Circular references I encounter circular references a lot and most of the time, it takes a long to time to figure out where the circular occur. Is there a way for MSP 2003 to show me all the dependencies/predecessors that caused the circular references? Thanks! Tag: Adding tasks to OLAP cube Tag: 69189
  - 16
    - Duration in Resource View I'm currently using MSP2003. Is there a way I can see the duration/remaining duration of a task in the Resource Usage View? Thanks! Tag: Adding tasks to OLAP cube Tag: 69188
  - 17
    - Project Calculate on incomplete tasks I am currently using MSP2003. I would like to know how to calculate a possible complete date when the predecessor tasks are partially complete. Currently, if the tasks are at 0% complete, the calculation is easy and automatic. However, if the tasks are partially complete (20%, 60%, etc..), is there a way to calculate the projected complete date by the remaining durations base on the % complete? Thanks! Tag: Adding tasks to OLAP cube Tag: 69187
  - 18
    - horizontal lines is it possible to cause project 2002 to print horizontal lines on the gantt chart, for example after every 5 or 10 tasks, in order to make it easier, on a large project document, to trace the line from the task name to the task bar? Tag: Adding tasks to OLAP cube Tag: 69185
  - 19
    - open pre 1998 project files I am using MS project 2000. I need to open some MS project files dated 1997. Is there any utility available for transforming these files into a format I can open. Thanks bartmacl Tag: Adding tasks to OLAP cube Tag: 69181
  - 20
    - More Questions How does MSP determine the critical path? What is the criteria? Tag: Adding tasks to OLAP cube Tag: 69175
  - 21
    - Microsoft Project Users Group in Washington DC I am starting to learn to use Microsoft Project. Can anyone suggests a users group in Washington, DC or Arlington area? Thanks. Tag: Adding tasks to OLAP cube Tag: 69174
  - 22
    - Exporting MS Project Data to Microframe Project Manager (MPM) MicroFrame (now Business Engine) used to support a program which create a flat file (comma-delimited) that can me used to export MS Project data to MPM. I believe it was called Microframe Project Link, or MPL. Does anyone know the structure of the export file (i.e. the fields exported and the order of the fields)? I'd like to try to create an application that does the same thing since MPL is no longer in existence. Does anyone know of any other way of doing this? Thanks! JR Tag: Adding tasks to OLAP cube Tag: 69170
  - 23
    - Calculate Work I want Project to do some resource allocation. I want Project to calculate how men I need to get the job done in a certain time frameFor example, I have a task that is scheduled to take 600 work hours to complete...if my men each work 40 hours a week, how many men do I need to complete this job on time. Tag: Adding tasks to OLAP cube Tag: 69169
  - 24
    - send e-mail prior to task Is it possible for project to send an e-mail through Outlook to parties about pending task? Tag: Adding tasks to OLAP cube Tag: 69167
  - 25
    - Building a schedule I am trying to build a schedule, I have specific start and finish dates for numerous tasks. Is there a way to add in the specific dates without adding a constraint? Also, I started my schedule from listing in Gantt view by first identifying my tasks and then going back to modify the dates for each task. Is this the best way or is there something better? Thanks for any assistance!!!!!!!! Tag: Adding tasks to OLAP cube Tag: 69163
- Next
  - 1
    - Compatable with Zire 72 Can anyone tell me if MS Project 2000 can be used with Zire 72? Thank you Tag: Adding tasks to OLAP cube Tag: 69162
  - 2
    - Resource Over Allocation I'm using Project 2000. I am needing to identify by resource group any overallocations. Based on the nature of the projects it appears the easiest way to do this is to assign by groups not individuals. My thought process is to make resources such as Engineering, Testing, QC, etc. I have a couple of questions regarding this approach: 1. Would I change the max unit % in the Resource Sheet to correspond with the number of individuals in the Group. Such as if there are 10 Engineers the max unit % would be 1,000? 2. Is there a way then to show the amount of hours not tasked for the day/week? I hope this makes sense. Thanking everyone in advance. Tag: Adding tasks to OLAP cube Tag: 69160
  - 3
    - Date format in Header Hi all, Trying to do something simple but not having much luck. In the header/footer of a task sheet, I'm trying to get the saved date to print in the format 'd mmm, yyyy'. The default format for the date in the project is DDD yy mmm dd, and I'd like to keep that for now. Is there a way to use switches to alter the date format in the header/footer? --dkp Tag: Adding tasks to OLAP cube Tag: 69159
  - 4
    - Resource cost clarification How do I set specific parameters to my material resouce cost? In other words, 10ft. of pipe costs $15 and for task 3 I will use 3 units (30 ft.). Tag: Adding tasks to OLAP cube Tag: 69154
  - 5
    - Customising Fields Is it possible to customise the Baseline Cost field? I have tried via Tools, Customise, Fields and although Cost is specified as a type, Baseline Cost is not included in the list. Currently it allows me to overtype any of the baseline cost fields and does not rollup the figures to the summary tasks. Tag: Adding tasks to OLAP cube Tag: 69147
  - 6
    - MS Project - Web Approach??? Hi, Is possible to use MS Project over the web? Actually I am looking for tool for: - Project Planning/scheduling - Resource Management - Project Collaboration - Risk Management I need fast track what resources are on which project (web based). Please, I need help in this. If is possible to do that please tell me how, if is not I would like to know what alternative is? THANKS Tag: Adding tasks to OLAP cube Tag: 69144
  - 7
    - Changing work I have a task set up as fixed work and effort driven. Its set up to 40 hours work. When assigning one resource to 100 % everything is ok.=20 The duration i set up to 40 h. When changing the allocation to 80 % the duration is set=20 to 50 h. So far so good. After this I assign one additional resource and set that=20 one and the previous to 50 %.=20 Now the duration is set to 49.23 hours. The work still is=20 40 h. I don=B4t understand this calculation. Anyone else who does. Tag: Adding tasks to OLAP cube Tag: 69142
  - 8
    - Printing Multiple Reports Currently using both MS Project 2002 and 2003. On a current project I'm having to print as many as 20 reports at a time for various stakeholders. Has anyone seen/got a macro that they've developed to automate or batch multiple reports ? Tag: Adding tasks to OLAP cube Tag: 69140
  - 9
    - Add button and resource name is dimmed when build team from enterprise Dear expert, Add button and resource name is dimmed when I will build team from enterprise. so i can't select and add resource to project team resource. why? and how fixed it? I am using microsoft Project Professional 2003 and Project Server 2003 upgrade from project server 2002. Tag: Adding tasks to OLAP cube Tag: 69131
  - 10
    - setting task starting time by hour? I have a weekend project that starts on Friday night and finishes Monday morning. How do I tell Project 2000 to start a task at a specific time (say 8 pm) on a specific date (say august 6), but not at 8 am (which is the native start time)? The start/finish format doesn't seem to have an obvious way to designate specific times to start or finish. Thanks in advance for any advice. Andy Tag: Adding tasks to OLAP cube Tag: 69129
  - 11
    - Project Hangs I have a client who uses Project 2000 on Windows NT. Frequently, Project hangs and they receive a Dr. Watson error. They have 512M of memory and 1700 tasks. Any ideas? Thanks! Tag: Adding tasks to OLAP cube Tag: 69127
  - 12
    - Filters to include the Summary Task I would like to filter on % complete, resource and date. That is no problem, but if a task is selected by the filter, I would also like to include its immediate summary task. How do I pull this in? The summary task typically doesn't have the resource name on it. Tag: Adding tasks to OLAP cube Tag: 69121
  - 13
    - Printing a report of % completed? Hi, is there a way in project 2002 to print a report that merely tells you all the work that has 'not' yet been completed and what their %'s are? Right now I have a custom column that is % complete, my boss has given me the oh so fun task of figuring out how to just print the report based on that column, whats left to work on and the percent. Please help =) -Jason Tag: Adding tasks to OLAP cube Tag: 69119
  - 14
    - Sharing Calendar I am using 2003 standard and I have created a calendar for our company with the specific days off that we take. I want to use this canendar in all my projects. Is there a way to make the default or at least share this calendar? Tag: Adding tasks to OLAP cube Tag: 69117
  - 15
    - Adjust task bar height I have yet to figure out how to adjust the task bar height on my project so that the longer named tasks can be seen within the bar on the screen and when I print my project. I guess what I'm looking for is something similar to the "Justify" option for cells in MS Excel. Any ideas??? Tag: Adding tasks to OLAP cube Tag: 69112
  - 16
    - Multi-Project Resource Leveling with Project Server 2003 Do you open multiple enterprise projects in MS Professional 2003 and then resource leveling, saving all projects back to the project server? Or do you have to dump all the enterprise resources into a separate project, then open all enterprise projects you want to level across, level them, and then save them back to the server? Tag: Adding tasks to OLAP cube Tag: 69111
  - 17
    - Indicators don't show in printing My project view includes the Indicators column and it shows icons in both view and in Print Preview. Yet when I print it, the cells in this column are blank. Any ideas? Tag: Adding tasks to OLAP cube Tag: 69106
  - 18
    - Project WG for Outlook We are trying to use the task based feature of project with outlook with good results but have two systems that keep getting an ole error. WGSETUP.EXE is what is needed to bring project and outlook together to deligate task to specfic people within outlook. The error I keep getting on the systems is "One or more OLE controls failed during initialazation. Reinstall workgroup features and then try agian." We try do the reinstall and it open outlook and get the same message. Any Ideas or help on this greatly appreaciated. Tag: Adding tasks to OLAP cube Tag: 69102
  - 19
    - Document libraries in PWA We are a software house just starting to pilot MS Project 2003 & Project Server. I want to ask our project managers to publish product development documentation via the PWA Documents page. There are different sets of doc for different phases of the development lifecycle, e.g. specification, testing, beta etc So ideally I would like to get a standard set of libraries to come up when the subweb is created for the project upon publication to the project server. Surely this must be possible via Sharepoint but I can't see a way of doing it. Can anyone help please? Tag: Adding tasks to OLAP cube Tag: 69101
  - 20
    - assigning more than one parent task to a sub task Hi, I'd like to share 2 parent tasks for a sub task. for example: The sub task is "meet a & b" currently placed under parent task called "finishing initial plan" I'd like it also to appear under parent task "meetings" - not as a copy, but as the same task, just with 2 parent references. How can it be done ? Tag: Adding tasks to OLAP cube Tag: 69095
  - 21
    - Preventing task going accross two days I have MS Poject sort all of my jobs by priority then schedule them based on based on available resources. All jobs are less then a day in duration so when the next job will not fit into the balance of a day, I want it to be moved to the next day. To complicate matters I then want project to identify the next highext priority job that can be scheduled into what was left of the previous day. Any suggestions or am I asking to much? Tag: Adding tasks to OLAP cube Tag: 69082
  - 22
    - Date and Time stamping on tasks Is it possible to track date and or time stamping on tasks being updated so you can track oldest tasks to current updated tasks. I am working on a large project plan of over 6500 tasks and to enable me to track tasks more efficiently, we want to be able to sort tasks that haven't been updated in a while. Can that be done? Tag: Adding tasks to OLAP cube Tag: 69081
  - 23
    - entering bills and invoices is it possible to enter multiple entries into the "actual cost" column of a single task or resource then be able to review each seperate entry? (i.e. in construction a project may have 50 tool rentals that all belong to the "tool rental" task) Tag: Adding tasks to OLAP cube Tag: 69079
  - 24
    - Project 2002 vs. Project 2003 What are the key differences between the two products? Why should I upgrade to 2003? How does it function with Sharepoint (if it does, where can I find out how to set it up)? Thanks, Tag: Adding tasks to OLAP cube Tag: 69074
  - 25
    - Varying Weekly Hours for One Task? I am trying to schedule a software architect to execute a singel task over an 8 week period. The first week, they will dedicate 30 hours, each week thereafter, they will dedicate 10 hours. How can I track this variable hour allocation within a single task? Much Obliged, Chris McTiernan Tag: Adding tasks to OLAP cube Tag: 69073

Hi all,

the solution is ready!
Please download here:
http://make.bogdanov-associates.com/eng.asp?rubr_id=476

You might also like some other stuff we published like GanttZoomer, etc.

Regards,
Vadim

Top

Re: Adding tasks to OLAP cube by dgoad2002

dgoad2002
Wed Jan 26 07:34:38 CST 2005

Vadim Bogdanov wrote:
> Hi all,
>
> the solution is ready!
> Please download here:
> http://make.bogdanov-associates.com/eng.asp?rubr_id=476
>
> You might also like some other stuff we published like GanttZoomer,
etc.
>
> Regards,
> Vadim

Vadim,
Is ther any cost for the Portfolio ANalyser Extender?

Thanks,

-dave

Top