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

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

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

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

Any insight on this issue will be appreciated. I am trying to create a report where the metrics will be calculated based on date range(two prompts). Here is the tricky part. The prompts have to be attribute element list prompts. The second prompt must be populated using the first prompt...

VLDB was set at report level to use look up table as the where clause driving tables. However, my relationship filters ignore this setting. For example: Report filters on Location and Time. All passes without relationship filter has where clause such as "WHERE LU.Location = 5 and...

The min/max qualification for hierarcy prompt does not work. For example, create a new prompt and choose 'Choose from all attributes in the hierarchy' option. Select a hierarchy, then check the box 'Choose default prompt answers'. On the next screen, check Minimum qualifications, and Maximum...

Is there a way to use dynamic dating based off of user inputed date instead of the 4 choices provided (Today, This Week, This Month, This Year)? I have a client who wish to create a report to track marketing campaign. Here is how the report should run. Upon execution, the user enters a...