OLAP Cubes to be used in Excel

[arunjhalani]

I have made OLAP Cube from our ERP database (Oracle). The Problem I am facing is Hiding the Some of the Fields in the Pivot Page fields. Can we hide those in the Page Field and how that effect can be made into the Grand Totals for the Pivot ?

 

[Mark W.]

Do you mean hide some of a Page field's items? If so, are these items checked or unchecked?

 

[arunjhalani]

I am sorry for the Delay
Ya it is Hiding the Data & their Corresponding VAlues in the Data field
e.g. When I refresh the Cube, It gives me the data till today. If I have to See the data For the Last MOnth or Till Yesterday, I am Not Able to hide the data in the Page Filed.
I have to Drag the Page field to Row Or Column & then Unchecked it.

My Quest relates to This , Can I hide it in The Page Field ?

Thanks in advance

 

[Mark W.]

No, you cannot not.

 

[dk]

No, you cannot not.

Does that mean you can?