Search results for query: *

Does anyone know why Oracle can not support the following join? select a12.COLUMN_1 COLUMN1, (a11.COLUMN_1|| a11.COLUMN_2) COLUMN2, a12.COLUMN_3 COLUMN3, a12.COLUMN_4 COLUMN4 from L_TABLE a11 join F_TABLE a12 on (a11.COLUMN_1||a11.COLUMN_2) =...

Teccum, Thanks for your reply. That is our current work around also, but copying over the db on a daily basis is causing us too much overhead.

I am in the process of creating a quick prototype from a MS Access database stored in a network folder. Here is what I have done so far. I haved made sure that the logon used by the MSTR machine has access to the folder and the MSTR server instances is started with the same login. From the...

We have had similar issues where certain rows of data were from an excel file. Here is what we did to get around the issue. We have our Mstr report dump data to a excel template. Sheet #2 is used for Mstr data, and sheet #3 for the excel spread sheet. Sheet #1 is formatted to reference the...

I had a needless second pass in both parts of the applysimple. It should be: ApplySimple("(select year(date(max(DT_LST_UPDT)- 2 MONTHS))*100 + month(date(max(DT_LST_UPDT)- 2 MONTHS)) from udbadm.RPT_EVNT_STS WHERE (#0) = 1)",1) AND ApplySimple("(select year(date(max(DT_LST_UPDT)))* 100 +...

Nick, thanks for the quick reply. Actually, I found a easier approach which does not use any MSTR objects in the apply simple. Here is the solution: ApplySimple("(select year(date(max(DT_LST_UPDT)- 2 MONTHS))*100 from udbadm.RPT_EVNT_STS) + (select month(date(max(DT_LST_UPDT)- 2 MONTHS)) from...

There was a similar issue posted last year but I don't think there was a solution to it. Here is the issue: We have an attribute qualification filter that uses custom between statement with an embedded value prompt: ApplySimple("year(date(#0) - 2 MONTHS)*100+month(date(#0) - 2 MONTHS)"...

My mistake in my first reply. You can set custom header/footer to display and print the date, but when exporting, there is no option to export the header/footer. You may want to look in to post macros and have excel run an macro up on export to add the date.

Try custom footer/header option.

I had similar issue that I tried to fix by using the VLDB setting but was never able to specify only one left outer join. It will do it for all. I got around it by creating a view that did the correct join and brought it in to the project. I am almost certain that the VLDB settings can not...

Open up the report in edit mode. Go to menu option Data / Report Data Options / Display. Set the attribute alias to Deal Desc. No need for the other attribute.

Check Country attribute and region attribute from both version (7.1 vs 7.5)and make sure that they match. Do the same for the table keys on those tables (7.1 vs 7.5)

Please post the SQL with both attributes on the template.

I think this should work... Create your prompt 3 as follows. 1. Create a hierarchy with just the Supplier attribute. 2. Filter the Supplier Attribute from the hierarchy editor using the Supplier Name Search filter. This combines Prompt 2 and 3. Users will enter the supplier name string, then...

If it is a requirement to have the Period Attribute going across the horizontal axis, the the YTD will always repeat for however many elements are brought back for the report.

What is on the report template and what are the filters if any?

Here is the issue, any help will be appreciated. I have a report with a secondary prompt. Once the report is returned, I go to menu option View / Report Filter. The Report Filter options does not display what was selected in the secondary prompt. Is there a way to expose this through a...

I don't think there is an option anywhere in the web interface to turn off 'page by'. You may want to look creating a view in the database and applying the filter there.

Can you give more detail on why you are using the page by to filter the attribute elements displayed? You also stated that you didn't want the users to see that the report is using the page-by. At that point, you are better off just putting report filter on the attribute and limiting the...

Open up the report in desktop. Go to Grid menu option. Make sure the Merge Row Head Header Cells option is not pressed in.