I'm using Oracle Analytics v5.9 , I have a datawarehouse including a bridge table for implementing a hierarchical dimension. I cannot find a way to join this table with my fact table and my dimension table. i even created a view joining bridge table with Dim table but still no luck. does this version even support what i'm trying to do..? thank you in advance.
many to many relationship in oracle analytics
84 Views Asked by saman tr At
1
There are 1 best solutions below
Related Questions in DATABASE-DESIGN
- Big data with spatial queries/indexing
- Unique hash/index for time interval
- Best practices for creating a huge SQL table
- Database Design: How should I store user's news preferences in MySQL database?
- Is it recommended to use Node.js for an online room booking web application?
- Storing multiple item settings in database
- Which column type for storing the year field in a table with rows of yearly data
- Best way to setup a i8n in a database
- Database normalization for electricity monitoring system
- Database Design: Unique Billing Assocation
- Is it always a bad practice to have circular relationships in your database design
- One column maps to mutiple columns from different table
- Replicating tables within the database
- mysql one translates table vs multiple translate table
- Nosql database design for complex querying
Related Questions in DATA-WAREHOUSE
- Big data with spatial queries/indexing
- Joining date and time field in Tableau
- Talend Open Studio for Big Data
- spark stream and spark sql with data warehouse
- Errors in the OLAP storage engine: The attribute key cannot be found when processing
- Anchor modeling - tie: make first role?
- Is star schema still necessary for a big-data-warehouse?
- How to batch export raw data from Omniture (SiteCatalyst or Adobe Analytics)
- Omniture Data Warehouse Segments Issue
- Plotting data cubes
- SQL Server Storing DateTime as Integer
- When we use Datamart and Datawarehousing?
- How to merge two or more queries with different where conditions? I have to reuse the code which is being used in 1st where code
- Structural difference between Relational Databases vs. Multidimensional Databases
- Shell Script to Validate Filename
Related Questions in ORACLE-ANALYTICS
- Oracle analytic function - using FIRST_VALUE to remove unwanted rows
- How could I connect Power BI to Oracle Cloud Analitics?
- Dynamic Column selection in BI Answers/views based on Dashboard prompt selections
- Hiding a column in pivot table if the column is null in Oracle OBIEE
- Is it possible to import Excel file into OBIEE or OAS and use it with other subject areas?
- How to achieve string concatentation of entries in column having same id in Oracle Analytics Cloud Professional Edition?
- OBIEE RPD: Snowflaked table not showing up as a fact table in the BMM layer
- Oracle Analytical Desktop Variable Prompt issue
- Merging workbooks in OAD (Oracle Analytics Desktop)
- see physical SQL in oracle analytics cloud reports
- How to find the sum of each group which is grouped by another group?
- Oracle remove rows from a query set based on sum
- SQL query : How to retrieve minimum value from top to that row in Oracle
- Bringing records from separate rows into one
- Difference between the values of multiple rows in SQL
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Multi-table dataset and Join many to many is available in 6.0.
You can find a video on the YouTube Analytics channel:
https://youtu.be/AaMR80PXl18
You can find also more information on features here:
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acswn/index.html#ACSWN-GUID-CFF90F44-BCEB-49EE-B40B-8D040F02D476
Hopefully this is helping you.
Ben