oracle application express 4.1 apex combine applications on to one dashboard page

Posted on 2011-10-21
Last Modified: 2012-05-12
apex combine applications on to one dashboard page

I have built 3 database applications which are based on 3 different excel spreadsheets.
Rather then have 3 different logins for each page I would like to be able to have a dashboard page as a separate application and then have a link to each application. This would only require 1 login.
Is this possible or have i gone about building apps the wrong way.
Thanks in advance.
Question by:dplinnane
    LVL 20

    Expert Comment

    I may be misunderstanding the question, but why do you need 3 separate *applications* ? Why not just 1 application containing 3 sections (corresponding to each spreadsheet)? Then you could easily control the user access to each section based on the user.
    LVL 1

    Expert Comment

    I agree with gatorvip.

    Use only one application, and not three..

    Author Comment

    So I have an application called PATCH_LOG.
    I am on a workspace that I created called OCTWORKSPACE.
    I am logged into the workspace as admin.
    Under Home ->Apllication builder

    PATCH_LOG  + REQUEST_LOG + 3 other apps.

    I have the option of RESET IMPORT EXPORT CREATE
    If I click CREATE I will create another application.

    If I want to add another excel spreadsheet app to the RESET_LOG app
    I click on the RESET_LOG App
    Now I am in
    Home ->Apllication builder ->application 104
    The only option I see here is Create Page

    Is this what I need to do to create an other excel application.

    I'm a bit confused on how to get around and combine apps

    LVL 20

    Accepted Solution

    What version of APEX are you running?

    How you proceed depends on what you want to manipulate the spreadsheet data. Typically, this data needs to be loaded into an Oracle table.

    For example, in your administration interface, go to SQL Workshop, then Utilities / Data Workshop. Under Data Load, click on Spreadsheet Data (note, you will have to save your spreadsheet in CSV format first). Once you go through all the prompts, you will have loaded the data via the APEX interface and then you can proceed with reporting (or whatever else you need).

    Author Closing Comment

    did not answer fully

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now