.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Same hierarchy name across 2 different cubes

Posted By:      Posted Date: September 17, 2010    Points: 0   Category :Sql Server
Hi Assume that I have 2 hierachies, one with attributes Year-Month-Days and one with Year-Month-Week-Days. I want to use hierarchy A in cube A and hierarchy B in cube B, but want to label both the hierarchies as the same name. I know it's a weird requirement, but is this possible?

View Complete Post

More Related Resource Links

Hierarchy ID: Model Your Data Hierarchies With SQL Server 2008


Here we explain how the new hierarchyID data type in SQL Server 2008 helps solve some of the problems in modeling and querying hierarchical information.

Kent Tegels

MSDN Magazine September 2008

Test Run: The Analytic Hierarchy Process


Most software testing takes place at a relatively low level. Testing an application's individual methods for functional correctness is one example. However, some important testing must take place at a very high level-for example, determining if a current build is significantly better overall than a previous build.

James McCaffrey

MSDN Magazine June 2005

Organization Hierarchy - Manger not showing


SharePoint 2007 SP2 on Server 2008 R2

I am doing a custom profile import using AD and a BDC connection.  All the data comes in and populates correctly, including the 'Manager' field which is being populated from the BDC entity. All main fields are being populated from the BDC entity.  Fields are; First name, last name, email, office and cell phone, and manager.

However, when viewing the Organization Hierarchy, the users 'Manager' is not showing up in the Hierarchy. Nothing above the current user is shown in the Hierarchy.  The Manager field is populated with a valid user.  If I display the Manager field in the 'Details' section, I can see the name and click on it to see their profile page as well, so it is all valid and accurate.

Colleagues ( users with the same Manager ) are listed in the Hierarchy, but none of their hierarchy's show the manager either.

I have deleted every profile and then done a full import several times with the same result. Incremental import does ont have any affect either.

Any suggestions or advice on how to get the Manager to display?

Thanks to all!


Video: SharePoint 2010 Object Model Hierarchy

This video describes the hierarchy of the most commonly-used objects in SharePoint 2010. (Length: 2:18)

MDX to get a count on a hierarchy

Hi I want to get the number of customers that placed orders for items from more than 2 Product Category in a month in the Adventure Works 2008 DW database. Can someone help me with the MDX expression? thanks

Determining the status os the Batch job that process SSAS Cubes

Hi All, I have a cube and that is processed through a batch job. The problem I am facing is there are many packages which are calling this Batch job to process the cube. Is there a way to determine the state of the job before the packages call this batch job to process the cube. And in which database can I find all the information about the jobs on the server. Thanks for your help. Vineeshvineesh1701

Process cube - other cubes get processed

When I process a single cube other cubes are getting done as well. Am I right in assuming that is because they share dimensions ?

Processing Cubes

HI ALL, I have processed cube first in INCREMENTAL PRocess mode ,then i got doubling of data ,will anyone have knowledge how to avoid this doubling of data,is this possible to eliminate the same with the help of PROCESS DATA MODe with the help of SSIS     Amit

WWF and hierarchy

Good morning guys: We are currently on the process of doing some research to find the right technology for our next project and even I've read a bit on WWF I have these questions that I would really appreciate if anyone can help me solve these: 1. We have a product component hierarchy, it means a product is composed by many components. Products and components might have different states (state machine), so, is it possible to define an workflow that handles this hierarchy? I mean, finally this is like 2 workflows right? 2. Would these be like 2 different workflows? Thanks for any help!

Business explainfor tables and hierarchy in AdventureWorks database and REAL_Warehouse_Sample_V6 cub

AdventureWorks (ProductModel table, what is this table for) ------------------------------ REAL_Warehouse_Sample_V6 (Periodicity(only have one attribute:period)) (Replen Strategy(three level hierarchy(strategy type:backlist,frontlist);(strategy:Modeled,Buyer Managed,No replenishment,Store Managed)) Another one is what is the difference and relation between buyer and customer in cube REAL_Warehouse_Sample_V6? -------------------------------------------- I can not understand the business meaning behind these tables and architecture,can any one help explain the meaning for upper hierarchy and table? happyMan

reporting from multiple cubes

Hi, i am new to SQL server 2008 and i am investigating the possible use of SSAS and report builder for my task. i was wondering wether the following scenarion is possible; Breaking down my db into several small cubes made up of different business model; ex Sales, Budget, Stocks, etc. Then using report builder creating my different reports. My reports could be based on one specific cube(ex sales). Is it possible with report builder to create a report which will take measures and dimensions from more than one cube? for example i have to get a report for one specific outlet giving me the actual sales per product but also the forecasted sales from my budget. In this case i have my actual sales information coming from my Sales cube and the forecasted sales comes from my Budget cube. How do i link my cubes in report builder so that i can do such a report.   thanking you in advance,   cheers

Unable to get Lastperiods 4 periods in time hierarchy at different levels.

Hi, I am unable to get last 4 periods when the weeks are falling at two different months. Example: The calendarsales contains the following hierachy : Year, HalfYear, Quarter, Month, Week August month contains the following weeks:1033,1034,1035 July month contains the follwing weeks: 1032,1031,1030. So i am selecting the week 1035 and i need last 4 weeks till 1032. But the below qry is returning last 3 weeks 1035,1034,1033. It is unable to retrieve 1032 as it is coming under previous month of July.  Below is the mdx query i am using. **************************************** WITH     SET ORDEREDCAT AS   Order ( [Dim_Product].[ProductDefaultHierarchy].[Category]. MEMBERS ,[Measures].[Sales Units] , BDESC )     MEMBER [Measures].[SalesUnits_L_4WKBP] AS   Sum ( ( {   LastPeriods (4 ,[Dim_RetailerSalesCalendar].[CalendarSales]. CurrentMember ) } ,[Measures].[Sales Units] ) )     SELECT     NON EMPTY {[OrderedCat]} ON 1 ,{ [Measures].[SalesUnits_L_4WKBP]     } ON 0 FROM   [Aroyale] WHERE   {[Dim_Retailer].[Retailer].&[5]}* {[Dim_RetailerSalesCalendar].[CalendarSales].[week].&[1035]} ***************************** Please can any one help me on this. Regards, Srini.

Performace point/Excel services OLAP cubes

Running Sharepoint 2010 Ent fresh install.  I have created a new site and performance point service as instructed in the following tutorial. http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx I have then uploaded an Excel document which pulls data from OLAP cubes.  The Excel doc as a standalone works fine.  After it has been uploaded users can open it as normal etc but when changing slicers and trying to pull info from the cubes I get the following error.. An error occurred durning an attempt to establish a connection to the external data source.  The following connections failed to refresh: "Name of out cubes here" I have been playing with the secure store and generating keys etc to no avail.  I have tried exporting the .odc file from the Excel document and uploading it to the data connections library/dashboard site but this doesnt help The anoying thing is that I had it working once and then the next day it failed for no apparent reason and even after a fresh install I cant get it to work again.  Any pointers or tutorials would be greatly appreciated! Andy

modelling SCD2 hierarchy changes in analysis services 2005

its seems to me its really not possible to implement SCD2 changing hierarchy in analysis services such the hierarchy is properly displayed in excel. for instance if scd2 changes happen on leaf level then excel correctly shows the data but if they happen on branch level analysis services picks up one parent eg at time 1 hierarchy looks like this A->B at time 2 hierarchy is A->C when hierarchy is displayed in excel 2007 it shows      time       1       2 C    100   200   A  100    200   but this not a correct display of hierarchy changing over time the correct display is this      time       1       2 B    100   A  100 C            200   A          200      

SSAS 2008 attritube hierarchy doesn't group records and repeat rows

We are having problems with the dimension attributes in lower level hierarchies not grouping under 1 single level. Here is the hierarchy: VP    College      Department         Departmental Course            Course Level               Course Number The top 3 levels are grouping correctly without duplicate rows and they don't have compoud keys. The lowest 3 levels are not grouped correctly and they have compounds keys because the attributes are not unique by themself. The result of the hierarchy looks like this: VP Academic Affairs    Business School of Management        International Business School            Mgm101                 Lower                       Course Number 123            Mgm101                Upper                

MDX to retrieve data from Time hierarchy

Hi there, I have a time hierarchy Year->Quarter->Month->Day. I need to get all the level data by one MDX.  Desired result set should look like Year    Quarter    Month    Day  MeasureValue 2010    Q1           Jan       01     1000 2010    Q1           Feb       28     500 Thanks, Palash

Dynamic SQL statement for a multilevel hierarchy report

Basically I have a requirement from the functional team that need to show a multilevel hierarchy report.   ID ParentID A NULL B A C A D B E C F C G F   The above is the sample of the table.   I need to show the cascading relationship dynamically base on the available level. The issue was we would not know how deep the relationship in the table.   Target Result:   ID Parent Level 1 Parent Level 2 Parent Level 3 A NULL NULL NULL B A NULL NULL C A NULL NULL D B A NULL E C A NULL F C A NULL G F C A
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend