Group items tagged

Report Freeze/Fix Column Header

Tabular Tabular Column Validation Limit Length of Text Field Entry Tabular Form's Column Read-Only and No Duplication Tabular with Popup When Hovering Over Column Identify Column ID of Tabular Form Javascript News Ticker Popup Window Checkbox to toggle show/hide a region Tooltip APEX Built-in Tooltip Box Over Tooltip Page Page Load Time

Entity Attribute Value

number of attributes (properties and parameters) which can be used to describe them are potentially vast, but the number of attributes which will actually apply to a given entity are relatively modest.

sparse matrix

The reality of the inbox is that people subscribe to a lot more stuff than they are committed to reading. As a result, they sift through the advertising and marketing noise to find the gems--the messages they connect with and that add value to their lives.

From your initial sign up process to the content and frequency of your messaging, your most important job is showing your audience that you respect the privilege of being invited into their inbox.

1) Do bad customer experiences cause people to switch brands? In a 2011 research project conducted by CX application vendor RightNow, 89% of consumers said that yes, a bad experience has spurred them to switch brands. But in the brand-new study of business-executive perceptions that’s the subject of this column, only 49% of the surveyed executives said yes.  QUESTION: What steps do you need to take to close this dangerous perception gap? 2) While 97% of executives say CX is critical to the success of their company, and 91% say they’re committed to making their company a CX leader, only 20% would rate their own CX initiatives as “advanced,” with a dedicated CX leader in place, initial projects pushed to the optimization phase, and the overall project extended to new channels and groups . QUESTION: What are the obstacles preventing you from aligning your actions with your words? If you say it’s a “budget” issue, aren’t you really talking about strategic priorities rather than line items? 3) Most companies have a clear and direct understanding of the looming CX challenge and the powerful interaction of social media. The study found that the top two drivers for CX initiatives are (a) rising expectations from customers (59%),  and (b) the impact of social media on customers’ ability to broadcast good and bad experiences (37%). Now, even if you’re able to somehow rationalize those findings, here’s one that not even the most-accommodating executive can dismiss:

4) Being a CX laggard can cost those companies many tens of millions or even hundreds of millions of dollars in lost revenue: executives estimated that the lack of positive, consistent, and brand-relevant customer experience can cause them to lose out on a staggering 20% in annual revenue.

Worse yet, all that money’s likely to wind up in the pockets of your competitors!

GL_JE_BATCHES (je_batch_id)                                   => GL_JE_HEADERS (je_batch_id) GL_JE_HEADERS (je_header_id)                                  => GL_JE_LINES (je_header_id) GL_JE_LINES (je_header_id,  je_line_num)                      => GL_IMPORT_REFERENCES (je_header_id, je_line_num) GL_IMPORT_REFERENCES (gl_sl_link_table, gl_sl_link_id)        => XLA_AE_LINES (gl_sl_link_table, gl_sl_link_id) XLA_AE_LINES (application_id, ae_header_id)                   => XLA_AE_HEADERS (application_id, ae_header_id)  XLA_AE_HEADERS (application_id, event_id)                     => XLA_EVENTS (application_id, event_id)    XLA_EVENTS (application_id, entity_id)                        => XLA.XLA_TRANSACTION_ENTITIES (application_id, entity_id) 

The source_id_int_1 column of xla.xla_transaction_entities stores the primary_id value for the transactions. You can join the xla.xla_transaction_entities table with the corresponding transactions table for obtaining additional information of the transaction. For e.g you join the xla.xla_transaction_entities table with ra_customer_trx_all for obtaining receivables transactions information or with mtl_material_transactions table for obtaining material transactions information. The entity_id mappings can be obtained from the XLA_ENTITY_ID_MAPPINGS table

Integration BI infrastructure: All tools in the platform use the same security, metadata, administration, portal integration, object model and query engine, and should share the same look and feel. Metadata management: Tools should leverage the same metadata, and the tools should provide a robust way to search, capture, store, reuse and publish metadata objects, such as dimensions, hierarchies, measures, performance metrics and report layout objects. Development tools: The platform should provide a set of programmatic and visual tools, coupled with a software developer's kit for creating analytic applications, integrating them into a business process, and/or embedding them in another application. Collaboration: Enables users to share and discuss information and analytic content, and/or to manage hierarchies and metrics via discussion threads, chat and annotations.

Information Delivery Reporting: Provides the ability to create formatted and interactive reports, with or without parameters, with highly scalable distribution and scheduling capabilities. Dashboards: Includes the ability to publish Web-based or mobile reports with intuitive interactive displays that indicate the state of a performance metric compared with a goal or target value. Increasingly, dashboards are used to disseminate real-time data from operational applications, or in conjunction with a complex-event processing engine. Ad hoc query: Enables users to ask their own questions of the data, without relying on IT to create a report. In particular, the tools must have a robust semantic layer to enable users to navigate available data sources. Microsoft Office integration: Sometimes, Microsoft Office (particularly Excel) acts as the reporting or analytics client. In these cases, it is vital that the tool provides integration with Microsoft Office, including support for document and presentation formats, formulas, data "refreshes" and pivot tables. Advanced integration includes cell locking and write-back. Search-based BI: Applies a search index to structured and unstructured data sources and maps them into a classification structure of dimensions and measures that users can easily navigate and explore using a search interface. Mobile BI: Enables organizations to deliver analytic content to mobile devices in a publishing and/or interactive mode, and takes advantage of the mobile client's location awareness.

Analysis Online analytical processing (OLAP): Enables users to analyze data with fast query and calculation performance, enabling a style of analysis known as "slicing and dicing." Users are able to navigate multidimensional drill paths. They also have the ability to write back values to a proprietary database for planning and "what if" modeling purposes. This capability could span a variety of data architectures (such as relational or multidimensional) and storage architectures (such as disk-based or in-memory). Interactive visualization: Gives users the ability to display numerous aspects of the data more efficiently by using interactive pictures and charts, instead of rows and columns. Predictive modeling and data mining: Enables organizations to classify categorical variables, and to estimate continuous variables using mathematical algorithms. Scorecards: These take the metrics displayed in a dashboard a step further by applying them to a strategy map that aligns key performance indicators (KPIs) with a strategic objective. Prescriptive modeling, simulation and optimization: Supports decision making by enabling organizations to select the correct value of a variable based on a set of constraints for deterministic processes, and by modeling outcomes for stochastic processes.

Create an Application to Upload Files Using Oracle APEX, In Less Than 10 Minutes (Video)

APEX includes declarative BLOB support that enables you to declaratively upload files in forms, and download or display files in reports (ittichai wrote about it here).

In the past, prospects primarily accessed information about a company by interacting directly with a salesperson.

As media evolved, mass ads, events, direct mail, and more recently, email, have been the primary tools for engagement.

The tag-management industry is growing rapidly, as tags are critical to gathering data about your customers.

It's the early days for tag management, but the industry is growing rapidly because it's not so much about tags, but about the bigger challenge of using digital data.

Where does tag management fit in the data picture? Here's an example someone shared with me recently: He had gone to an antivirus product's website, read the reviews, and bought the software. In the days that followed, however, he suddenly began to see banner ads from that same software maker whenever he visited CNN, ESPN, and other favorite websites. The software maker knew he had visited its website, but not that he already bought the product. They were retargeting him with banner ads at unnecessary cost and no purpose.

APEX 4.2 resizable interactive report column heading menu

Channel Optimization. Many marketers struggle to optimize each individual channel, let alone optimizing at a customer level across many channels. To the extent that Big Data can help marketers understand what is important in the moment and across touch points, that could be valuable, but it seems more of us need stronger attribution models and analytics methodologies more than access to data. Big Data does seem to be valuable if you want to understand which customers are highest value within each channel and across channels, because the platforms that manage Big Data can handle both structured and unstructured data - which is what you need to truly include Web/clickstream and social data in your analysis.

Big Data has been all the rage. But fast data, even if it is small, can be more valuable than complicated masses of information.

Here's why: All the focus on "bigger is better" has overlooked the fact that most Big Data segments have not been validated with a business application or value.

Those kinds of analytics can help you find the right streams to access and work with, and also can help you build out robust programs that identify valuable customers.

learn more about the brand or to be entertained or educated in some way.

Mapping out the ifs-ands-or-buts pathways for each persona can become complicated, so automation solutions such as Infusionsoft that offer a drag-and-drop interface can make the mapping of the funnel stages manageable.