As per the documentation it is working fine returning age in YYYYMMDD format as 21 years 02 months and 25 days for your case.
You need to format it or use some funtions to display accordingly..
Regards
K
I think you have a column (say person ID) in the group by function which forces the result to display the way you had mentioned.
If not, can be send the query generated for the report..
Regards
K
Hi All,
I am very new to SAP. And still in the process of learning. Please tell me what all needs to beconfigured in FI for PA and Py module to be used in SAP.
Its urgent please reply asap.
Thanks
swati
Just try this..
In the filter of the main tabular model, you can specify the outer join condition directly.. something like
tabularmodel1.productid = tabularmodel2.productid(+)
Hi All,
What are the Minimum requirements hardware(congif) wise for installing the visioninstance of oracle apps.
How difficult it is to do the installation???
And if one can tell me across Different OS it would be of great help.
preferable windows 2000 professional,sever and Win XP
Its...
Hi Everybody,
Can anyone help me with the concept of Web Application Dictionary. What is it??? Why do we need it and what are the advantages of having a Web Application Dictionary.
Awaiting a reply asap.
Swati.
Hi
I changed the url accordingly and ran the report and it is asking for prompt value. Do I need to change any run options for the report.
Here is the url...
I had added certain elements to CRN_HEADER_OPTIONS using the ui_add parameter in the 'system.xml' file and I could see the same in Cognos Connection page. But in the report viewer window, I could only see Cognos Connection link in the header. Is it possible to see the elements that I had added...
Hi
http://localhost/crn/cgi-bin/cognos.cgi?b_action=xts.run
&m=portal/report-viewer.xts
&method=execute
&m_obj=/content/package[@name='URL']/report[@name='City']
&outputFormat=HTML
&outputLocale=en-us
&prompt=true
&m_name=City
If I paste the above url in the address bar of internet explorer...
Can someone help me in adding a hyperlink in Cognos Connection Main page which when clicked should open a word document. Is this possible.. Please help..
Kumar
Is there a way to generate a file for all the filters that has been set against the tables, folders in a catalog for a particular user. As I am unable to see it, when I use the content overview method.
Thanks,
Kumar
Can anyone please help me. I am running the following macro and it throws the following error messgage.
Sub Main ()
Dim objImpApp as object
Dim objImpRep as object
On Error GoTo ErrorHandler
Set objImpApp = Createobject("CognosImpromptu.Application")...
When I run my report from my Impromptu Application, it runs very fast and when I run the same report from the web(IWR), it is taking long time for the same set of input values. Is there any other setting that I should make while configuring IWR. Please let me know if anybody is aware of this...
Can any one explain me how to do the incremental cube build using macros and also how to design a model for incremental cube build. Thanks in advance..
Kumar
check the following :
Whether there is any filter with condition
"second_column is not missing" in the report
(or)
Try creating the second prompt like this
"if second_column is null then 'value is null' else second_column"
Run the report and check whether it...
Hi,
Thanks for ur help.
Let me explain it once again. I have 500 user id for 500 customers and I had applied a filter on the the customer table as mentioned table
user : customer 1
filter : customer_id = 1
user : customer 2
filter : customer_id = 2
like that for 500 customers.
Now I had...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.