EssMDXIsCellGLDrillable

Checks whether the cell is associated with a drill-through URL.

Syntax

ESS_FUNC_M EssMdxIsCellGLDrillable (hQry, hCell, pIsDrillable);

Parameter	Data Type	Description
hQry	ESS_MDX_QRYHDL_T	Query handle
hCell	ESS_MDX_CELLHDL_T	Cell handle
pIsDrillable	ESS_PBOOL_T	True, if the cell is associated with a drill-through URL; False, otherwise

Return Value

If successful, sets pIsDrillable based on the cell's status.
If unsuccessful, returns an error message.

Example

#define ESS_MDX_CELLPROP_GLDRILLTHRU         0x00000008

   if ((sts = EssMdxNewQuery(hCtx, qry, &hQry)) != ESS_STS_NOERR)
   {
      printf("EssMdxNewQuery failure: %ld\n", sts);
      exit ((int) sts);
   }
   printf("EssMdxNewQuery sts: %ld\n", sts);

   if ((sts = EssMdxSetQueryCellProperties(hQry,
          (ESS_MDX_CELLPROP_GLDRILLTHRU 
          )
      )) != ESS_STS_NOERR)
   {
      printf("EssMdxSetQueryCellProperties failure: %ld\n", sts);
      exit ((int) sts);
   }
   if ((sts = EssMdxExecuteQuery(hQry)) != ESS_STS_NOERR)
   {
      printf("EssMdxExecuteQuery failure: %ld\n", sts);
      exit ((int) sts);
   }
   printf("EssMdxExecuteQuery sts: %ld\n", sts);

/* To retrieve IsCellGLDrillable property of a cell, use EssMdxIsCellGLDrillable*/

   if ((sts = EssMdxIsCellGLDrillable(hQry, hCell, &bIsCellGLDT))
      != ESS_STS_NOERR)
   {
      printf("EssMdxIsCellGLDrillable failure: %ld\n", sts);
         exit ((int) sts);
   }
   if (bIsCellGLDT)
      printf(" Is Cell Drillable: TRUE\n");
   else
      printf(" Is Cell Drillable: FALSE\n");