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 Rhinorhino 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: *

  • Users: BlueBrand
  • Content: Threads
  • Order by date
  1. BlueBrand

    Powerprompts change to uppercase

    I can't get a prompt to change the value to uppercase and pass that to Impromptu. On the html page I change the case to all upper using style="text-transform: uppercase;", but that doesn't seem to pass to Impromptu. Seems should be simple... anyone know how to do this?
  2. BlueBrand

    Multiple selections in Dynamo

    In PowerPrompts version 7, I created a list box dynamo to allow for multiple selections. In the script to filter the report I have: GetQuery().AndFilterBy("[\\folder\\column] in (" + App.Variables("MyColumn") + ")"); What I end up with is the following, but I...
  3. BlueBrand

    Toshiba Laptop

    I have a Toshiba laptop with an internal wireless lan mini pci card. Can I connect that to my Linksys BEFW11S4 V2? I can connect using my pc with a Linksys wireless adapter, but my laptop just says Network cable unplugged. ( It is a wireless adapter though) Can I get this to work or else do...
  4. BlueBrand

    Cascading PowerPrompt Dynamo

    I want to create a cascading powerprompt dynamo in version 7.0, where a second dynamo filters based on a previous one. I tried using the WHERE &quot;TABLE&quot;.&quot;COLUMN&quot; = '<GetUserVar(&quot;MyUserVar&quot;)%>' syntax, but the GetUserVar doesn't seem to retrieve the value previously...
  5. BlueBrand

    Drill through target report blank

    In Upfront, when I attempt to drill from an iwr to an iwr the target report is blank. On my workstation it works using Impromptu. I'm using version 6. Any idea why it shows blank in Upfront?
  6. BlueBrand

    Open cube to current month

    How can I get a cube to always open to the current month?
  7. BlueBrand

    Self referencing table

    I want to build a dimension in Transformer from a self-referenecing table. i.e. CuatomerID, Name, ParentCustomerID 1, Jack, 0 10, Jill, 1 11, Jason, 1 20, Fred, 10 21, Frank, 10 So, a customer can both be a parent and have a parent, and I want a dimension that represents the hierarchy. What...
  8. BlueBrand

    Drill through from cube to ppx in powerplay web

    Using PowerPlay for Windows, I drill from an mdc to a ppr report. Can I duplicate that in Upfront going from a cube to a ppx report?
  9. BlueBrand

    measure headers in pdf

    When I export a cube from Upfront to .pdf, the dimension line displays in the header, but there is no header telling me what measure I am looking at. Is there a way to get it to show the name of the current measure displaying in the report? Thx.
  10. BlueBrand

    Trend over multiple years

    I have a cube that contains data from the last four years. The cube is quite large, and takes about five hours to build. Last year and previous data is closed and so is does not changed, yet I still include it in the build since users want to trend over all the years in a single graph. If I...
  11. BlueBrand

    Drill Through Filter

    From PowerPlay Web, if I am at the leaf level of a dimension and I drill through to impromptu, only the leaf category is passed to Impromptu as the filter. Can I get it to pass the whole dimension hierarchy to Impropmtu when I drill through from the leaf level?
  12. BlueBrand

    Drill Through filters

    Does anyone know whether it possible to reference values being passed from a cube to a 'drill through' .imr report? For example, if the cube passes Department='101', can I reference that in the .imr report as in 'where division = passed_in_department, in other words '101'.
  13. BlueBrand

    comet.dll

    I ran a utility named AdAware, and it detected comet.dll as spyware. Not knowing better, I told it to delete the file. Comet.dll file ships with Transformer, and is required to run the tool. I believe that the file has to do with the mouse cursor, but it's odd that AdAware classed it as...
  14. BlueBrand

    Year/Month as time category

    I'm using year/month for my time dimension, and when I drill down to an Impromptu report, is selects where '2001-01-01' <= Year||Month and Year||Month <= '2001-01-31' It doesn't work when Year||Month = '200101'. Any ideas?
  15. BlueBrand

    .mdl size

    Does anyone know of any documentation or have an opinion on mdl size and performance? i.e. Is there a .mdl file size that is 'too big'?
  16. BlueBrand

    TR3311

    I am accessing an Oracle db and creating .iqd files to use with Transformer. Part way through a cube build I encounter a TR3311 error. The documentation does not give too much help and I wonder whether anyone knows what that error means. Thanks.
  17. BlueBrand

    Impromptu &quot;not in dataset&quot;

    I need to join two tables using a substr() of a column. Using the example below, I want to join TableA and TableB by substr(TableA,1,4)=TableB unless there is a substr(TableA,1,6)=TableB. In that case, I want to use substr(TableA,1,6). I can do that in a SQL statement using a correlated...
  18. BlueBrand

    Embedded SQL and Impromptu

    A report I'm working on requires an embedded select as displayed below. What I do to use that in Impromptu, is paste the SQL into the query profile window. The downside is that I lose some functionality inherent to Impromptu since I'm limited to the sql statement. Anyone know of another way...
  19. BlueBrand

    Transformed TR1102

    When I attempt to open my model, I encounter error TR1102, informing that a level associated with a category count measure is not defined as unique. I'm not sure why it didn't error as I closed the model, but now, does anyone know how I can open it? Thanks.
  20. BlueBrand

    OLAP reference

    I'm looking for a good OLAP reference book from a 'PowerPlay' perspective. Sort of an &quot;Impromptu/PowerPlay Unleashed&quot; type of book. Anyone know of a good reference?

Part and Inventory Search

Back
Top