Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ggimmiwang

    How to design date interval enter box at prompt manager!

    As title, I need a date interval(ex. 20050801~20050831) report entering by user.In a word, while report was opening(in improptu 6),users can enter the date interval condition they like. I see the help, just see the one condition, how to design this prompt manager items!!! Thsnks a lot!!
  2. ggimmiwang

    how to split the big size cube on time

    Thanks for your opinion, and I'm trying now!! If it has any experience, I would back!! Thanks again!!!
  3. ggimmiwang

    TR0214-The temporary file for source file<>and Cube<>is empty

    hi, dear all: I try to use the "incremental cube" attribute, but the task is not work (the errow message show the TR0214). This made me not "updent" my cube, as a result, the cube size is big. thanks alot!!! the log file is shown as: http://home.so-net.net.tw/ggimmi/e11.txt Message TR0214 The...
  4. ggimmiwang

    how to split the big size cube on time

    The case I’ve met now is following: My boss ask me to split the cube we use now! Because the cube update is too slowly(the cube size now is about 5~600MB) How to split this cubes right now and do not interrupt its routine job. Can transformer6.6 & windos2K to adjust this request? Thanks for help!!
  5. ggimmiwang

    Why the cube is backward??? urgent please!!

    thanks for your helps! I ask to the system administrator for your opnion, and he adjust the folder permission I ever use. Now, I'm trying and hope success!! Thanks again!!
  6. ggimmiwang

    Why the cube is backward??? urgent please!!

    hi, dear all, thanks for help: My autobatch is following: trnsfrmr -n -s -z X:\*.pyi (since I'm keeper not original creator, what the "-z" means? I didn't find on doc or anywhere! ) and this is my log file: http://home.so-net.net.tw/ggimmi/e1.txt
  7. ggimmiwang

    Why the cube is backward??? urgent please!!

    When my cubes(*.batch) is updated, my cube size became smaller than the before one(becaue I once try to create it in transformer manually). Why do I use the transformer to create cube, the cube is updated normally and correctly(I can see the correct value on *.ppr!!), but, when my...
  8. ggimmiwang

    About error:TR3311 bulk fetch!!

    Is anybody in this trouble?? help me please!! error "TR3311" bulk fetch!! thanks !!
  9. ggimmiwang

    About error:TR3311 bulk fetch!!

    dear all: Thanks for helping. while I transform the cube, the process was interruped by error message (TR3311), and then I check the document about (error: TR3311) that is shown following: ------------------------ An error occurred during data retrieval from the database. Refer to Details for...
  10. ggimmiwang

    How to design a dimention about period-count quantity

    Thanks DoubleD It's so amazing! Now I'm trying to go the next steps(*.iqd -> transformer)! thanks~~ !!
  11. ggimmiwang

    How to design a dimention about period-count quantity

    I created a datefield table in database to solve the problem 1. above at first.(Because I want to trial the other in advance) when I add that calculated field as your opinion above: I got the 'cross product' error following : --------- **** ERROR **** This report will result in a 'cross...
  12. ggimmiwang

    How to design a dimention about period-count quantity

    hi,DoubleD: I'm back unfortunately!! ^_^||| 1.I try to create the "datefield" hotfile you suggested, the way I try to is create the each month in "Excel" then I save it as *.csv, but I do not see it(that hotfiles)in Impromptu's catalog->Tables->hotfiles->browse when I want to add it to the...
  13. ggimmiwang

    How to design a dimention about period-count quantity

    Thanks for reading!! 1.Where do I add this "Sum(If (DateField between (E_arrival_work_date) and (E_departure_date)) Then (1) Else (0))" 2. I have aready built a row data's iqd (which is compose of start-work & End-work field and etc..). where do I set the result-table(means the...
  14. ggimmiwang

    How to design a dimention about period-count quantity

    Thanks Mr.DoubleD!! I try to design the *.iqd you suggested, the result is not good because of "emoployee's work-time counting" !! ---------------------------------------- I have tried to use function "count",but the rusult-number just caculated only "a day" that employee's...
  15. ggimmiwang

    How to design a dimention about period-count quantity

    Thanks a lot for helping!! Now, I'm trying to design such *.iqd and test it, but something is confused me--> the "employee count" change very sooner, is any way to calculate it in dynamic updating??
  16. ggimmiwang

    How to design a dimention about period-count quantity

    Hi, thanks a lot first for helping! The situation is I want to design a dimention(measure) about the employees-quantity at our company(department)in one special period.I don't know how to design that!! ---- My data record ----------- E_id, E_name,E_dept, E_arrival_work_date...

Part and Inventory Search

Back
Top