You need to put "descending" in front of every variable that you want in descending order, otherwise it will sort in ascending order. ...descending var1 descending var2 descending var3...   //Fredrik ... View more

Hi! I dont know if this helps you, it was a while ago since I worked with cubes and MDX....:)   Here is a sample code on how we solved access to different levels of a dimension, I remeber that the <!--Condition--> was important to get it to work :). We defined groups in metadata tha correspond to the data in the cube and depending on which group a person belonged to that information was retrieved from the cube :   generate( Filter([Customer].[Customer Unit ID].[Customer_id].members,IN ([Customer].CurrentMember.name,"SUB::SAS.IdentityGroups")) , ascendants([Customer].[Customer Unit ID].currentmember) ) <!--CONDITION--> generate( Filter({[Customer].[Customer Unit Name].[Customer_id].members},IN ([Customer].[Customer Unit Name].CurrentMember.name,"SUB::SAS.IdentityGroups")) , ascendants([Customer].[Customer Unit Name].currentmember) )   generate( Filter([Customer].[Region ID].members,IN ([Customer].[Region ID].CurrentMember.name,"RECA")) , ascendants([Customer].[Region ID].currentmember) ) <!--CONDITION--> generate( Filter({[Customer].[Region Name].members},IN ([Customer].[Region Name].CurrentMember.name,"N Europe & Cent Asia")) , ascendants([Customer].[Region Name].currentmember) ) generate( Filter([Customer].[Customer Unit ID].members,IN ([Customer].[Customer Unit ID].CurrentMember.name,"100017")) , ascendants([Customer].[Customer Unit ID].currentmember) ) <!--CONDITION--> generate( Filter({[Customer].[Customer Unit Name].members},IN ([Customer].[Customer Unit Name].CurrentMember.name,"Verizon")) , ascendants([Customer].[Customer Unit Name].currentmember) ) ... View more

Try: upcase(substr(locationCode,1,1)) = 'Y'   Use it in an advance filter 🙂 //Fredrik ... View more

Just keep the ID column 🙂   Then use the resulting table to join with other data you need.   //Fredrik ... View more

You can set the permissions i management console. Use folders to store your different reports and data, restrict access to the folder via a groups in metadata. Add users to that group who should be able to access the report and the data.   Yopu can read more in the admin guide!   //Fredrik   ... View more

Yes, you can import one report into another via the menu.    You can add links to the reports from your home page. The easiest way to find the link is to open the report and then click send report.  In the email you will find the link. You can also add options to remove the banner and buttons so only the report is visible.  If you dont have single sign on the users have to log on for the first report.  //Fredrik ... View more

How about this? 🙂   data one; infile '\\Client\E$\SASData\StateData.txt' delimiter='|'; length inputstr rinput $200 states region $32 visits x z y $8 pos 8; input inputstr; rinput = strip(reverse(inputstr)); y = strip(reverse(scan(rinput,1))); z = strip(reverse(scan(rinput,2))); x = strip(reverse(scan(rinput,3))); visits = strip(reverse(scan(rinput,4))); region = strip(reverse(scan(rinput,5))); pos = indexw(strip(inputstr),region); states = strip(substr(inputstr,1,pos-1)); run; ... View more