Hi, I have a requirement where I need to display a Pivot dynamically as per the users locale. The numbers and the date format has to be changed from...
Hi Don, to help around this situation QIQ Solutions have created a free Utility called QIQ Lifesaver that allows you to save a BQY even when the recurring...
Hi Don, to help around this situation QIQ Solutions have created a free Utility called QIQ Lifesaver that allows you to save a BQY even when the recurring...
Socscappas, Many thanks for the tip. I've gone to the website and requested a copy, so I'll try it it. Thanks again! Regards, Don Harper Edge Technical Support...
Hi, Is there any way to change the label text of the Pivot totals dynamically from EIS ? We have a requirement where we need to show the totals as "Division ...
No. The pivot table object model is not revealed to that level. I complained about this very issue to Brio for 2 years and nothing happened. You can always...
Yes, as Mark said, the other way is to create a new column with the same formula, then delete the old column. This has the same effect as renaming the column....
Steve, sorry but that won't work - you can create a computed item and set its formula, you can modify a computed item and reset its formula, but there is no...
I was assuming he already knew the formula. Praveen, if these methods don't work, why are you trying to rename the column, there may be another way to tackle...
HI, all Question1: I am using var obj=new JOOLEObject("Excel.Application") to create an EXCEL Application Object. Everytime the program is run, a new Excel...
There is a way, but not in Brio. I wrote an Auto-Documentor for Brio using Visual Basic. I found a way to read the internal of a BQY and also how to document ...
Hi Khoar, I am very interested in reading the internals of the bqy, I am trying to programmatically (vb or something) change the EIS script code of a bqy. Are...
On version 6.x you can probably get this working on DB2/400. I was unsuccessful when I tried several years ago but believe now it was probably authority...
The "EXECUTE IMMEDIATE" statement is issued by the ODBC driver to the database. It is not normally available for your viewing. If you go into the ODBC...
Hello, Brio 6.X works without problems with a repository AS/400, but I had no luck in trying to install the 8.1.2 version repository on AS/400. During the...
Here is a snippet of the code I use to read Brio files. First you will note a test to see if the file is compressed. If so you will need to save it as...
Hi Jen, I don't think there is a way to do this conventionally, but if you merge the docs with QIQMerge you should be able to do what you need to. Adam Franz ...
Thanks for this khoar. I have altered the bqy successfully before, the only catch is prior to the EIS script snippet that you change you also need to change a...
Hi All, I have uploaded a file called utilities.dll, the dll contains an inputbox function and a nice date control popup box. Register the dll using regsvr32...
Any idea how I can get rid of duplicate rows? I want to do a Top 10 Report (by making a Computed Column with 1 and Cume'ing it with another Computed Column)...
Two ways of doing this. The ideal way if you can get away with it is to do a select distinct by going into the query options and selecting "Return unique...
Keith, While I try that option, here's the scenario that I am working on... I have a table with 3 columns : Order num, Order type (with values N,R) and...
You need to do a self-table join. Drag the Order table in twice and join on Ordernum then add a limit using ordernum or ordertype and then enter Custom SQL...
Hi, We are an international Information Technology (IT) company, with focus in providing Software Solutions, Software Products/tools, Software Consultancy and...
Thanks a lot ! Now I'm able to get the orders with order type N & R.. in a single query.. But, now I have one more issue...comparing the prices of the orders ...
I am using Designer with MS SQL Server OLAP, and I am having a problem: I am trying to dynamically change or create a variable side label dimension and there...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
