Adding "Job Filter" to "Analyses by Dimensi

Farukca
Farukca Member Posts: 19
edited 2004-05-27 in Navision Attain
Hi,
I must add a "Job Filter" to "Form 554 Analysis by Dimensions".
Job Filter will contain the one or more "No." data of "167 Job" table.
Of course when we select a job no; the entries, or sum of the entries which just belong to this Job record will be seen.

I have tried various ways but I could not do anything. Because all these analysises have been done on the "365 Analysis View Entry" and "366 Analysis View Budget Entry" tables. And in this tables there is no relation with the Job table.

Do you have any idea, then it will be welcome.
Please tell me if you have any idea..

Thanks

Comments

  • RobertMo
    RobertMo Member Posts: 484
    mission imposible ?
    maybe you could do your report another way - based on job entries ?
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
  • RobertMo
    RobertMo Member Posts: 484
    another idea:
    probably you have multiple dimensions.
    add new dimension "JobDim" and somehow relate it to jobs.
    you should take care about adding new dimension value for JobDim when new job is created, etc.
    when copying data in journals (at posting) you should take care that when "Job NO."<>'' you should add dimension value "DimJob"...
    and so on...

    then standard analysis by dimesnion should somehow work...
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯

Categories