Hello I am not able to add the image.. so I will try to explain in writing. Create a column prompt. Prompt for column - change the Fx to have following formula concat(CAST(Year("Orchestration Orders Details"."Creation Date") as CHAR(4)), concat('-',CAST(Monthname("Orchestration Orders Details"."Creation Date") as…

Hello PD001, Tried doing it slightly differently. Hope this is also helpful. VS

The Create Infolet option is still missing. I have tried reading many documents (wrong ones obviously) but not able to find how to show the 'create infolet' option. We are still in process of implementing SAAS (just Product Hub as of now). I believe there will be lot of priviledges not provided to my user. Can you share…

Hello, Thanks for your help. I am now trying to create a DataModel with sql query to get my desired output. However, I must say it is tedious. The table information is not very clear in Oracle documentation. In the meanwhile, I have been asked to use infolet to present some information. Though I could see documentation…

Thanks

Thanks all for the posts. I will try the options today/tomorrow and would revert with my comments. Cheers Vipin

Sahil and Syed, Thanks for your replies. I am not using the SQL for creation of the Analysis as yet. I have been working on 11i all these years. My table level (DB objects) knowledge is very limited. Question 2: Can you suggest, how I can find the tables related to the Product Hub. I read through few documents, not helping…