Interested to Buy Any Domain ? << Click Here >> for more details...
i am facing date format issue in webi report in BI4.0
environment.
i have unx based on Mysql connection.
date is coming in 10 digits numeric format like(2345623456).
I want to change it in dd.mm.yyyy format.
Please suggest
- 3 Answers
- 8870 Views
- I also Faced
- E-Mail Answers
Answer Posted / avijit paul
create a variables to get the individual digits and then
concat the extracted digits. you can change it to date
format also using todate().
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
What is difference between custom hierarchy and report based hierarchy?
What Is Snow Flake Schema?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Can we Save (save as) WEBI Doc as DESKI?
How to restrict password to a user while sending a document in .pdf format
in sap bi we have wad, then why we go for sap bo
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Explain the difference between union and group?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
What would you consider as your biggest achievement and why?
