Linked dimension (parent-child) has broken drill-down on analysis
We have the following scenario:
OLAP database 1 has a parent-child hierarchy dimension, which is available to perform analysis when browsing its cubes. Everything is fine here.
OLAP database 2 has another structure, however, the dimension above has been linked here.
We are facing issues when browsing cubes from OLAP database 2 and drop that dimension for analysis. The drill down performs an awkward behavior. Look:
Am I doing something wrong or this is some weird bug?
For whom it may concern, there is an answer on the thread i had opened on Microsoft Connect regarding the issue: http://connect.microsoft.com/SQLServer/feedback/details/814167
Basically, this is an unsupported scenario in MOLAP database engine and they closed the ticket as "wont fix". I've managed to clone the broken dimension in order to resolve that and it works like a charm.
Thank you
- Audit table update trigger does not work using a stored procedure
- Entity Framework | Sequence contains more than one matching element
- How can I alter column name in Sql server
- How to partition into batch of records with max batch size limit
- LOAD DATA INFILE error in MySQL
- Cannot perform an aggregate function on an expression containing an aggregate or a subquery with STRING_AGG
- Perform a row count of each table in my list of tables
- Entity Framework Core 3.1.6 Item With Same Key Has Already Been Added
- Split a string with no delimiters into columns
- Each GROUP BY expression must contain at least one column that is not an outer reference
- Add custom columns to pivot table
- Parameterized raw sql query much slower than query with actual values
- SQL Server database backup restore on lower version
- Add a value on their SESSION_CONTEXT for all sys.dm_exec_sessions
- How can I create a unique constraint on my column (SQL Server 2008 R2)?
- Summation of a column using certain conditions
- Natural join in SQL Server
- How to concatenate text from multiple rows into a single text string in SQL Server
- How to Renumber Set/Subset of Table Based on Numbering of A Second Table
- Using Azure Devops deploy release to multiple repos
- SQL Server Cursor vs WHILE loop
- SSIS: Insert multiple Excel files with same format but different file name to multiple database table destinations based on the Excel filename
- Seeking Advice on Efficient Data Unpivoting in SQL Server with SSIS or Alternative Tools
- SQL-How to Insert Row Without Auto incrementing a ID Column?
- Why can't I use an alias in a DELETE statement?
- Can ransomware encrypt a mounted SQL database? Hypothetical
- Grant user DDL permissions on specific schema
- How do I perform a GROUP BY on an aliased column in SQL Server?
- Collecting data from a joined table based on condition(s) in the joined table
- Stored procedure for auto generating roll no?