How can I link a report variable and a data provider variable in Desktop Intelligence 11?

Posted on 2008-11-18
Last Modified: 2013-11-15
I have a report pulling from multiple data providers, including an Oracle DB and an XML source.

The Oracle database has a field for the date/time... Date= 11/3/2008 12:00AM
The XML data provider has a timestamp date/time... Timestamp= 200811030000Z

I need to link these variables (Date, Timestamp) so that the data associated with the dates can be displayed in the same charts.

I have converted the timestamp (From the XML provider) to a date using the following formula:
=ToDate(SubStr( <Timestamp> ,1 ,8) ,"yyyymmdd")
which brings the formats in-line, but I am not able to link the two variables

What can be done in this situation (aside from manipulating the data sources) to associate the variables?
Question by:tdantona
    LVL 17

    Expert Comment

    Have you tried to link the two data sources using a LINK TABLE?

    This LINK Table could only contain the date columns of the original tables and have the same DATATYPES as the original fields in their original datasource.

    You could LINK the ORACLE to the LINK field in the link table and also the XML field to the link table,....???

    Just shooting from the hip here......????
    LVL 100

    Expert Comment

    Is this in a Crystal Report or one of the other BO products?

    Crystal doesn't provide great support for multiple data sources.

    How are you connecting to the 2 sources?


    Author Comment

    This is Business Objects - Desktop Intelligence.
    There are multiple queries running. Most pulling from an Oracle DB, but one is pulling from an XML provider, to create a report. I have not been able to connect the XML data to the Oracle data.

    CRXIuser2005's suggestion allows the data to be pulled into the same chart, but does not associate the date data... the result is not two data sets plotted separately by day (which is the desired outcome).
    LVL 17

    Expert Comment

    I was basically thinking about building this link logic into the Universe..?
    LVL 17

    Expert Comment

    I'm confused on why the Universe can't deal with the DATATYPE problem ..? Which it appears to be...?

    Do you have access to building a Universe..?

    Author Comment

    This is a large company, and other divisions/depts are using this tool.
    It may be an option to build/change a universe, but changes that affect other parts of the company are best avoided

    Do you know of any options for doing this without changing or creating universes?

    LVL 17

    Accepted Solution

    Well, I guess this wouldn't be a "change" this would simply entail a BUILD of a separate SMALL universe that contains this link I may not be as big a project as you may think.

    Other universes can remain unchanged.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    746 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

    15 Experts available now in Live!

    Get 1:1 Help Now