Search results for query: *

Hi entaroadun, I completely agree with what you say and thank you for giving some insight on how MSTR generates SQL. But in this particular report, when i count(fldtrackingnum) i want to have the 2 joins on a.fldrecnum=b.fldrecnum join uv_recorddetail c on b.fldtrackingnum=c.fldtrackingnum...

I have report with 1 attribute and 2 metrics.The attribute is Bill rep and the metrics are sum(adjamt) and count(trackingnum).I am using 3 tables uv_adjustdetails->Sum(adjamt) uv_payadjust uv_recorddetails->count(trackingnum) The sql is pretty simple and i am getting correct result on query...

I am using 7.2.3 and in this version i don't see "Include date" when exporting to excel but it is available for Print and export to PDF. do any one know if this option is available in advanced version?

Is it possible to display the date on the excel sheet when we export a report from the web which tells us when the report was exported?

I have table in which has a column "active" and the values are either 'Y' or 'N'. But on the report i have to field called 'Status' which displays like 'Active' or 'Not active' but not 'Y' or 'N'. In order to achieve this can i use "apply simple case statement REPLACE" with in the Status...

By default all the attributes are outer join in report data option.I worked around it but din't make any difference. I think as Jac74 said i have to work with view or in my case i can add a null row in the the table and use applysimple to convert that null value to some other value like "0" to...

I have a report in which i have set the "Preserve all final pass result" in the VLDB properties of the report.The SQL is as below: select distinct a12.BAN BAN, a12.MED_BILL_NAME MED_BILL_NAME, a13.ACCT_STATUS ACCT_STATUS, a14.ACCOUNT_STATUS ACCOUNT_STATUS from ODS_BILL_MEDIA a12 left...

Thank you very much entaroadun.Now i totally understand what the problem is.I will discuss this with the Modelling team and see if we can make the necessary changes. Once again thank you.

All supervisors reports to a manager. well,i have only one metric so i think metric inner or outer joins don't come into picture here.I think it has to do with attribute inner or outer joins. the issue here is when i drill down to the Supervisor level from manager level,i get only those...

I have a userprofile table with following columns: ID,supervisor(ID),Manager(ID).There are separate lookup tables for supervisors and managers to get the respective names.I will be joining fact table on the ID column of the userprofile which can be either supervisor or manager and the supervisor...

I have a report with drilling capability from director->manager->supervisor.The parent report will be at director level and i want sub total at this level and subsequently at manager level,supervisor level when i drill down. Can this be done? if not is there any alternative to show the subtotals...

I tried your applysimple and it is working good.Thank you. But now the user requirement has changed and they are asking for weekending date to be displayed on the report.so i am thinking of creating a new table with weekending column in it.is it the correct way to do it? or is there any other...

I have a table with date column in it (MM/DD/YYYY).i want week of the month to be displayed on the report and i am using applysimple("datepart(wk,datepart(month,#0)",givendate) but i am not getting the correct values. am i doing it in the right way? Thank you, Puneeth

Actually i want to use View Filter to display only certain rows of a report result set to the end user.But since we don't have OLAP licence we don't have that option availabe and i am using page by instead to diaplay those certain rows. So i was wondering if I can hide the page by on web and use...

I have a report in which i have to use page by to display only some elements of an attribute.But i don't want to display that page by option to the end user on the web.is there any i can use the page by option on a report in desktop and hide it to the end user on the web?

given below is the sql for the above mentioned report with some more fields added to it.The problem is i am getting same current responsibilty level and highest responsiblity level.Can you please help me in figuring out where the problem might be? current responsibilty level is obtained by the...

I have a report in which i have to calculate the metric first (some Max level) and then display only those records which satisfy a condition (some Id=1). I have query given below: select a11.fldApprovalId fldApprovalId, a11.fldResponsibilityLevel fldResponsibilityLevel, max(a11.fldRuleId)...

i don't understand what object prompts or view filters has to do with accessing warehouse catalog?

I did everything, it still the same. but other people are able to access!

when i click on the warehousecatalog on the schemai get a message "invalid procedure call or argument" and i am unable to access the warehouse catalog. do any one of you faced this problem? if so please let him know how to work around it. Thanl you.