When creating a one line table in Oracle BI Publisher using a Data Table, it will give you redundant filtering options on the titles of the table and an unnecessary subtotal at the end of the table if there is a fact in the table. Instead, we would like to have a similar table but without the filters and the subtotal. To do this we will add a Layout Grid to the dimensions that we have predefined. This will give the overall BI Publisher report a much cleaner look by removing two of the features of the data table. … Read More
An Analysis Design that will Allow Users to Create Custom Reports in OBIEE
Recently, I have been toying with the idea of having an OBIEE report that would allow the users to customize which columns would be shown in a particular report. This idea was going to be hard to execute because allowing users to customize the report that they would want to see on a dashboard would require the XML driving the analysis to change dynamically. A solution to this problem will not give the user 100% control of which columns are added to a report but it will allow them to have more control creating a report that they’re interested in. … Read More
Oracle Portal 10g SSL Problem
If you’ve run into an issue running Oracle Portal 10g with SSL (POODLE), we can help fix it for you. Reach out using the quick contact form in the footer. We would love to help.
Is Oracle’s Vision Corp Guilty of Gender Inequality? An OBIEE Analysis to Investigate Reports
Allegations of Vision Corporation’s activity in gender salary discrimination is something that Oracle’s Vision Corp takes very seriously and have been generous enough to open up all of their information for independent analysis by the public. We will begin an investigation of their full time employee’s salary information to see if the allegations of gender salary discrimination are prevalent in this corporation. We will be using OBIEE 11.1.1.6.0 to investigate. The first thing we will look at is a generated table and pie chart that calculates the number of employees by their gender. We can see that there is a … Read More
Amazon Web Services on Salesforce
There is an App available from Salesforce that makes connecting S3 buckets and EC2 instances incredibly simple. Referred to as the Amazon Toolkit. With Salesforce as a leader in the SaaS world, one might not see why integrating with AWS, a leader in the IaaS world, would be beneficial. Salesforce allows you to create incredibly simple custom apps for just about any requirement, but the raw data in these apps tends to be tucked away and hidden. Sometimes an organization might need to analyze data beyond Salesforce’s capabilities, or as a way of saving costs by backing up older records and … Read More
Assigning Group User from Apex
Public Groups in Salesforce.com serve as a useful tool to share content in an environment with multiple users. In our projects at M&S, we have used public groups in a variety of capacities including assigning users to records based on record criteria. In this post, we’d like to show you the benefit of using public groups for users outside of the traditional Salesforce assignment. One useful aspect of Public Groups is that you can manipulate the group without effecting custom code. For example: If you have a line of code similar to the following: String userId = UserInfo.getUserId(); User u … Read More
Sending Emails from Apex
Salesforce allows administrators to send emails based on workflow actions that are triggered within the environment. You can perform the same functionality utilizing Apex trigger code after you set your trigger logic. In this example we are going to send an email to an Account Owner once an Opportunity has been created for their Account. We will cover the following functionality: Querying the Account object for the Owner Querying for the required Email Template Establishing the email Sending the email //list for emails List emails = new List(); //query email template object EmailTemplate et=[Select id from EmailTemplate where name=:’Hello … Read More
Storing Record IDs from a List View in Salesforce
Built into Salesforce is the ability to add buttons onto List Views. This is an extremely helpful and powerful solution for updating records without needing to navigate onto the record detail page. In this blog post, I aim to cover how to implement selecting records to update, along with handling multiple record selections. Part 1: Storing and Passing IDs Salesforce provides built in syntax to capture the user selected record. In the button logic you will need to provide this piece of code: var oId= {!GETRECORDIDS($ObjectType.Object)}; This stores the user selected record Id into a variable which then can be … Read More