Search results for query: *

[date item in report] - current_date or _days_between(current_date, [date item in report]) others as well..

Sounds like the columns are auto-sizing based on the column content. So if the largest data item in section 1 is 10 char then the column sizes around that. If section 2 has a data item that is 20 char long then the column sizes around that and is larger than section 1. Manually size the...

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?

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...

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...

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...

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?

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

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...

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?

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.

Could be as simple as insufficient resources to complete the task. Could be that the cube is corrupt. What database are you using?

Any idea why the .csv file build would be faster? The .csv files are not indexed, so how does Transformer read them faster? Is it simply because they are not restricted by the database processing?

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...

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?

The date range that is passed in is something like StartDate=(2002-01-01, 2002-02-15). That range is passed from PowerPlay to Impromptu. My main Impromptu query then returns the rows: ID NAME START_DATE 101 Joe 2002-01-01 103 Jack 2002-02-03 But, what I want in...

Thx for the reply. What I want to do is reference the passed in filters in the Impromptu report. So, if PowerPlay passes something like &quot;Department=101&quot; to my Impromptu drill through, then in Impromptu I want have a filter set up that uses the value &quot;101&quot; that is passed...

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'.

What is the data source for the cube? Does it get its data from the RDBMS but just doesn't contain some of the data that you want in the report?

Myself, I prefer the .iqd files. I've had some bad experiences with text files and such. I agree with Brad's suggestion of filtering out unwanted data from your .iqd files. No need to include data that is not relevant. Also, perhaps some analysis is necessary to determine what data is...