Hi Guys, we have an internal website that we want to link to in our web reports but the requirement is to add a SAS web report or browser language of the user to that link. right now the STP is very simple and I wonder if there is a variable (global, session?) that would tell us which language the user is using to look at sas web report studio or finaly info delivery portal. data _null_; file _webout; put ''; put 'Link to language specific product details'; put ''; run; Thanks Bob ... View more

Hello, I am looking at some MDX that takes into account the SAS.IdentityGroupName or SAS.IdentityGroups. If the user that has logged in, is part of the Group="SalesTeamLead" then this agent should see all descendants of the group he/she is part of. For example: Dimension_Sales_Levels -Region ---SalesTeam -----SalesAgents Security_Groups -SalesAgent -SalesTeamLead Does someone Note: One user will only ever be part of one group. I tried the following as a filter for the management console but had no luck. SELECT IIF( SAS.IdentityGroupName IS 'SalesTeamLead' , Ancestors(Head(Filter([DIM_SALES].AllMembers,[DIM_SALES].CurrentMember.Level.Name = 'SALESAGENT' and [DIM_SALES].CurrentMember.Name = 'SUB::SAS.Userid')).Item(0)) , NULL ) FROM [mycube] ... View more

Hello, I have used the concept of "shared members" with Oracle Hyperion Essbase OLAP and wonder how I can apply this concept to SAS OLAP. We have a dimension that contains bottom level members that occur under multiple levels and parents and their siblings. The concept of "shared members" means that the data values associated with a shared member comes from another member with the same name. The shared member stores a pointer to data contained in the other member, and the data is stored only once. To define a member as shared, an actual nonshared member of the same name must exist. For example, the 100-20 member under 100 stores the data for that member. The 100-20 member under Diet points to that value. Shared members typically are used to calculate the same member across multiple parents; for example, to calculate a Diet Cola member in both the 100 and Diet parents. Is there a similar concept in SAS or would I have to ensure members have unique names and are hence stored multiple times in the cube? ... View more

Hello, our plan is to link one relational data report (with some prompts to filter the data) to another relational data report that just shows additional data from the selected key (row). Unfortunately the "Report Linking" option does not show up. http://support.sas.com/documentation/cdl/en/citug/61084/HTML/default/images/report-linking-menu.gif Is this due to false configurationof Web Report Studio 4.2 , how to fix this? regards, bob ... View more

Hello, I have written this simple MDX query and it takes more than 1 minute to execute (the timer is still running as I am writing this and it looks like my EG 4.2 crashed). SELECT NON EMPTY { [Measures].[FACTSUM] } ON COLUMNS, NON EMPTY CrossJoin (NONEMPTYCROSSJOIN (NONEMPTYCROSSJOIN (NONEMPTYCROSSJOIN ( { descendants([DIM_KPI].[All DIM_KPI] )}, { descendants([DIM_PERIOD].[HRH_CALENDERPERIOD].[All HRH_CALENDERPERIOD]) }), { [DIM_CUSTOMER].[DISCRIPTOR].AllMembers }), { descendants([DIM_SZENARIO].[All DIM_SZENARIO]) }), { descendants([DIM_SALES].[All DIM_SALES]) } ) ON ROWS FROM [mySmallCube] WHERE mySmallCube.... NOT IS MISSING AND mySmallCube.... NOT IS MISSING AND mySmallCube.... NOT IS MISSING AND mySmallCube.... NOT IS MISSING AND mySmallCube.... NOT IS MISSING AND mySmallCube.... NOT IS MISSING AND ...; The cube is build from a fact table with 14! facts. So an ms excel spreadsheet is faster than the OLAP cube in the moment. I wonder why this is? Have I done some big mistake in the code? The descendants are an average of 4 Levels and are about 100 members whereas the DIM_SALES has about 3000 members in total but are only two are important because I have an MDX filter on the cube that only gets members from the DIM_SALES dimension where they equal my user id. Thanks for any hints, Bob ... View more