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 Wanet Telecoms Ltd 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. bertdijks

    Global Settings

    This is not an global setting. (Go to: Tools --> Options --> The General tab Select the Always ask before opening documents with macros check box.) If you don't want users to run queries you can use the settings in supervisor
  2. bertdijks

    Aggregate Issue

    Or use 2 different context for each of the two fact tables (and enable the creation of multiple sql's in the options of designer)
  3. bertdijks

    Concatente function WebIntelligence

    try using & or +
  4. bertdijks

    Cannot click on Report Tabs in new InfoView Installation

    What is your browser version. You need atleast IE 5.5. We had similar problems with 5.0, there were solved by using version 5.5 or higher
  5. bertdijks

    Drop Down List to a Text Box on InfoView

    Question: Did you only adjust the SQL in the report, or dir you also change it in the universe?
  6. bertdijks

    Is there a way around not being able to filter on measures?

    Sometime ago I had the same problem, this was my solution: Replace {= If <CP COPIED SUM> >=1 Then "Some CP copied" Else "No CP copied to SU" ” } with {= If <CP COPIED SUM> >=1 Then 1 Else 0} and use the ranking function to show only the highest values. (top 1 will probably work, otherwise try...
  7. bertdijks

    Dilema when having to change universe for a given report... any help?

    The mapping in the reports is based on the ID of the object in the repository. For the universe the report looks to the universe name. If you make an identical universe with the same object names, the report will recognise the universe, but not the objects! My suggestion is to change the...
  8. bertdijks

    Remove Duplicates

    Try to identify which instance you want to select, for example with the first date (orderdate, changedate, etc) =If (<date>) = (max(<date> in <partnumber>)) Then "Dup" Else <Part Number> You will not be able to use this as a filterm because this is an agregation function. As a work-around you...

Part and Inventory Search

Back
Top