Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Please!!! Connection with password and user id
Hi!!! I have an OLAP connection in ASP Page, I can see the dimensions and measures, but when I code an userid/password (who have restricted permissions) in the string connection, OLAP Server do not recognize these permissions. I have a Windows 2000 Network and I am using its userid/password... -
Working with filters in MDX
Hi Issahar!!!!! How are you???? I proved the code that you sent to me, but it did not work to me. I continued looking for and exists a Filter function that in theory would allow to make what I need, but this only works if it is in rows or columns, as that form to me does not serve to me... -
Working with filters in MDX
Hi Issahar!!!! This is an example of the type of consult that i need, but in this consult i don't use the clause AND. I need to introduce logic operators, in this example "xxx > 20%" SELECT {[Gender].[All Gender].Children} On Columns, {CrossJoin(CrossJoin([Marital... -
Working with filters in MDX
Hi Issahar!!! Thanks for your answer, but i need know how include logic operators in my consult, since the type of consult that need built use logic operator for compare elements with values, percentage and/or measures. I know that in the where sentence don't can use logic operators, but in... -
Working with filters in MDX
Hi friends!!! I need work with filters in MDX, but I don't know how can use the multiples sentences in the clause WHERE or WITH, for example SELECT ..... ON COLUMNS FROM SALES WHERE or WITH gender="F" and Store="USA" and Products="Drink" and Age="20 years... -
Filtros en MDX
Amigos: Necesito saber como puedo agregar filtros a una sentencia MDX, por ejemplo Ventas de todas las personas > 20 años, sexo=F, de un pais determinado, y de un producto en especial Muchas gracias Karin -
How can I get Calculated Members????
Hola efr, si hablo español, te cuento un poco mi problema. Tengo una página en ASP y hago conexión al cubo a través de ADOMD, por lo investigado solo se pueden rescatar medidas, dimensiones y tambien crear miembros calculados con MDX (with member), pero necesitamos obtener los miembros... -
How can I get Calculated Members????
I don't speak Inglish sorry!!! I have a ASP and I connect with a Olap Cube with ADOMD. I get the dimensions, the measures, I can create calculated members but I don't know how to get the calculated members that are create in the server Please help me!!! Thanks Karin.
