Hi Sunil,
Thanks for your blog entries. I was very impressed with the custom Go button description. I am a fellow Siebel CRM/Analytics consultant doing this work since 99.
On a personal note, I see your last name is Ranka and was wondering if you are from Rajasthan. I know few people with Ranka last name who are from the town (Sadri)where we are originally from. I was born and brought up in Bombay. Just thought of saying hi and regarless of your origin we can certainly be each others contact from OBIEE perspective.
Your quick response is highly appreciated.
Below is the business scenario:
We are using OBI EE 10.1.3.4
1). Date Prompt (Start Date & End Date — Dashboard Prompt)
2). Product Category Prompt.
When we click on the single go button for the above two prompts
a). If the recordcount is less than or equal to 65000 then the report should be displayed in the dashboard. for displaying this we don’t any issues.
b). But for below.
If the data is more than 65000, then the report should not display instead of that “A message should be displayed” like Count is more than 65000, then the user should be able to download the data in to CSV file. As huge amount of data will be populated in the data mart per day (data feed from source system — Atleast 5 lakhs of data per day).
Let me know whether we need to write any Java script for the above scenario.
In the BMM layer we are planning to have only the Join conditions between the fact & dimension tables (Complex joins).
Also please let us know whether we will have any performance considerations if we populate the only the basic join conditions in the physical layer and in the BMM layer. All the calculated condition will be taken care off in the Data Mart.
Is it possible to design a drill down in which when we perform a drill the child level is shown in place as a collapse layer without hiding the other parent levels, somehow a drill down which works as hidden panels where is the child level and clicking the parent level are expanded in place, but having the possibility to expand another parent level and see in place the two expanded parent levels with their respective child levels shown.
It was great to meet you on Saturday.
Good to know that you have a DJ and Karaoke group.
We should meet some day and do some jamming together.
How many people you have in your group? When do you guys meet? Where do you practice?
What kind of songs do you guys sing?
Please let me know more about your group.
Anupam Nandwana said
Hi Sunil,
Thanks for your blog entries. I was very impressed with the custom Go button description. I am a fellow Siebel CRM/Analytics consultant doing this work since 99.
On a personal note, I see your last name is Ranka and was wondering if you are from Rajasthan. I know few people with Ranka last name who are from the town (Sadri)where we are originally from. I was born and brought up in Bombay. Just thought of saying hi and regarless of your origin we can certainly be each others contact from OBIEE perspective.
Regards,
Anupam Nandwana
anandwana@gmail.com
Siva said
Hi Sunil,
Your quick response is highly appreciated.
Below is the business scenario:
We are using OBI EE 10.1.3.4
1). Date Prompt (Start Date & End Date — Dashboard Prompt)
2). Product Category Prompt.
When we click on the single go button for the above two prompts
a). If the recordcount is less than or equal to 65000 then the report should be displayed in the dashboard. for displaying this we don’t any issues.
b). But for below.
If the data is more than 65000, then the report should not display instead of that “A message should be displayed” like Count is more than 65000, then the user should be able to download the data in to CSV file. As huge amount of data will be populated in the data mart per day (data feed from source system — Atleast 5 lakhs of data per day).
Let me know whether we need to write any Java script for the above scenario.
In the BMM layer we are planning to have only the Join conditions between the fact & dimension tables (Complex joins).
Also please let us know whether we will have any performance considerations if we populate the only the basic join conditions in the physical layer and in the BMM layer. All the calculated condition will be taken care off in the Data Mart.
Thanks in Advance
Siva
Razi said
Hi Ranka,
This blog is really excellent.
But we are having the scenario where:
In the Date Promt when the user select more than 1 day in the date between prompt, then the message should be display as “Select data only for 1 day”.
Can you please send the Java script for restricting the user to select only 1 day and then display the above message.
Also please let me know how to add more conditions to narrow it down to a single edit box in a particular page.
Pablo Sanchez said
Hello, maybe you can help me with the following:
Is it possible to design a drill down in which when we perform a drill the child level is shown in place as a collapse layer without hiding the other parent levels, somehow a drill down which works as hidden panels where is the child level and clicking the parent level are expanded in place, but having the possibility to expand another parent level and see in place the two expanded parent levels with their respective child levels shown.
Thanks.
Sheetal Kasliwal said
Hi Sunil,
It was great to meet you on Saturday.
Good to know that you have a DJ and Karaoke group.
We should meet some day and do some jamming together.
How many people you have in your group? When do you guys meet? Where do you practice?
What kind of songs do you guys sing?
Please let me know more about your group.
Regards,
Sheetal