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!

Register Log in
  • Congratulations Chriss Miller 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. ianhawksey

    Maximum size for measures and levels/columns

    Thanks for the info
  2. ianhawksey

    Maximum size for measures and levels/columns

    Environment: Transformer & Report Studio 8.3 I have been asked to find out the maxiumum size for measure names and column names. To try to be clear, I mean the length of the measure name (e.g. Sales Qty) not the maximum length of the data it can hold. Anybody know? Thanks in advance
  3. ianhawksey

    Modify measure rollup In Transformer 8.3

    Ties Thanks for replying. I am aware that percentages are not additive, these numbers are used in further processing/manipulation for average values, but the user also needs to know the actual values at granular level. To make sure I understand your reply: are you suggesting 2 measures: one at...
  4. ianhawksey

    Modify measure rollup In Transformer 8.3

    Hi I have a requirement to alter the rollup of a percentage measure. The scenario is this: My dimension is Plant / Supplier / Part. At the bottom level, Part, I want to report the actual percentage , eg. 90% or 170% etc. However, when rolling up to the supplier level, I want to effectively...
  5. ianhawksey

    MDX and Transformer

    Hi Ties. Thanks for the reply. If I understand you correctly, when you were building the cube you were dynamically filling in the missing records with a database view. The problem with my scenario could be the time to do that re the huge number of records and the resulting disk space used...
  6. ianhawksey

    MDX and Transformer

    Hi Guys I am using 8.3 Framework Mgr, Transformer, Analysis Studio, Report Studio, over Oracle. I have a database with c10 million rows, essentially date based. I need to fill in the gaps between records, by essentially adding 'dummy' records. For example, I have records for Week 1 and Week 4...
  7. ianhawksey

    Question re WorkFileSortBufferSize in Transformer

    Hi guys I am working on 8.3 with large volumes of data, upwards of 50 million rows (don't ask). We build the cube on a Unix server, and are having problems with running out of disk space. One of the things I am looking at changing is WorkFileSortBufferSize. The setting in the script xml for...
  8. ianhawksey

    Need Impromptu macro to change table owner

    Hi Guys I am trying to migrate an Impromptu 7 catalog from Informix to SQL Server. The table names are the same but the owner(s) is different. I understand it can be done with a macro. I have several owners which all need to end up as 'scheme'. Can anybody provide me a macro to change the table...
  9. ianhawksey

    Problem with Cognos and Dell core 2 duo computers

    Yes, Dell Core 2 duo Inspiron 6400. I haven't used this machine much in production, so I am not sure how much of a problem this will be.
  10. ianhawksey

    Problem with Cognos and Dell core 2 duo computers

    Hi I haven't encountered the exact problems you have. But I have had some strange things happening, like PowerPlay aborting unexpectedly, and transformer sceeens not being redrawn properly. I thought it was just my machine, but maybe not ? Interesting .... Ian
  11. ianhawksey

    How to schedule PowerPlay ppx report

    I had come to the same conclusion - save the ones to be scheduled as ppr. Enhancement for next year ? Thanks for the reply.
  12. ianhawksey

    How to schedule PowerPlay ppx report

    Yes it could be saved as ppr. However unfortunately there are a number of existing reports which will need to be scheduled, and they have all been saved as ppx because this is the default type.
  13. ianhawksey

    How to schedule PowerPlay ppx report

    Hi Guys I have PowerPlay Client 7.3 MR1. I want to use Cognos Scheduler to run a ppx report. The Scheduler only recognises ppr. Any suggestions ? Thanks Ian
  14. ianhawksey

    Migrating PowerPlay Reports to Production

    if the cube names remain the same, and the dimensions/measures re unchanged then everything should be fine. you may need to 'point' the reports at the new cube location if it's different. you can do this by selecting the tick box 'prompt for location' before openinf a report. Hope this helps Ian
  15. ianhawksey

    Upfront 404 file not found

    will try this out. thanks for the help
  16. ianhawksey

    For open the local cube in Powerplay

    This is the type of problem you get if you have not applied the Config Mgr changes - you can only see remote cubes. Go into Config Mgr, select the machine name, then click the apply icon. HTH Ian
  17. ianhawksey

    Upfront 404 file not found

    Hi Guys Just installed PPES, IWR etc. version 7.3 MR1 on W2003 server. I cannot access Upfront - I am getting "HTTP Error 404 - File or directory not found. Internet Information Services (IIS)" I have re-checked the IIS settings, and Config mgr, services etc seem OK. I can publish a cube to...
  18. ianhawksey

    Sorting Dimension Values in dropdown lists

    use the 'order by' tab on the dimension property sheet. this should do the trick. Regards Ian
  19. ianhawksey

    Category updation while cube recreation

    by default categories are regenerated on each cube update.old categories which are no longer needed remain in the model until you either manually remove them or run clean house. by default the cube is recreated from scratch every time. the 'update cube' option is a quick way to update the cube...
  20. ianhawksey

    effect of deleting categories

    Hi Lynne if you clean house, you will potentially lose those children under the manual levels if they have not been touched. if they then need to be included in subsequent cube updates, the catgories will be brought back into the cube as orphans (because you removed the parent/child...

Part and Inventory Search

Back
Top