Search results for query: *

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

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

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

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

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?

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

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.

I have an attribute "Username" with Id and Desc forms.when i use prompt for this username,same names are repeated multiple times. can any one please give an idea how i can restrict this to display the names only once. Thank You

I have report and a Dill map associated with it and the drilling works good on the desktop.But when i try to drill on the web for the same project,i get a error message : "Error in report results Your request could not be processed due to a server error. Please try again. If the problem...

I DID SENDNOW FOR GRAPH REPORT AND IT IS NOT RETURNING ANY INFORMATION. it just returns an "X "crossed display when i open the HTMl attachment .secondly i dont get all the pages of the graph. i am using lotusnotes if there are any issues with lotusnotes any help will be greatly appreciated thanks

I have 3 tables. Table1: adjid(PK) Recnum(FK) Totadjamt(Fact) Table2: Recnum(PK) TrackNum(FK) Table3: Tracknum(PK) Bill rep Manager Location These are views with real time data. I want a report with metric as sum(totaladjamt) with tracknum,billrep,manager,location as dimensions. I created...

Hi: i need help in creating fact.i have a dimension table with date_dm and week_dm. thers is one fact with date_id from dimension table.when i want to create a fact at week i need the week should have 8 days for 1 week not regular 7 days per week which i have currently .can anyone explain how...

hi what is materialized view or summary table and can we use it in sql

I have two columns Startdate and enddate and i need one more column (startdate-enddate). I am using a metric for totaldays applysimple("datediff(d,#0,#1)",startdate,enddate) But when i validate ,it says object of type 'startdate' is not allowed! if any one know how to do this please let me...

i am in a network and say sql server is running in one of the machine on the network and i want to add myself to the sql sever, h to find the machine and add user in that server

when i go to sendnow option and click i am not able to see html option in delivery format .

i configured EM but no data is returned. IS_REP_FACT HAS ZERO ROWS.I have checked EM CONSOLE, project configuration etc...EM_dm_user and IS rep_fact is not getting populated...any help at the earliest