How can we deal with unknown member in cubes for data mining?

Hot Topic

checking length and triming the value at ','!
Basing Report on a Procedure with Cursor
SP1 Installation Failure for Reporting Services Instances
How does service broker reprocess messages after a restore?
Is 64 bit excel driver (of office 2003 or office 2007) available now?
SSAS: Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))
How do you use the upgrade.exe for sqlce 2.0 to sqlce 3.0?
Embedding literals in RDL that will come through in HTML
Reporting Services with Axapta
How to Reuse functions in script tasks ?

SQL Server

Upgrade to SP1 breaks Integration Services.
Excel connection error The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error
Fail to Connect Report Service via Management Studio
missing date
DataReader Source and Column Types
Installation Error
Package crashes without error information
SQL Mobile Installation Problem on Device
Two Y axis Display
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance

How can we deal with unknown member in cubes for data mining?

Hi, all here,

I currently have a question about unknown member in cubes (as we know, there is always an additional member called unknown in an OLAP dimension)for data mining. I mean is there any way for us to deal with unknown member in cubes when mining cubes

Thanks a lot in advance for any guidance and help.




Answer this question

How can we deal with unknown member in cubes for data mining?

  • satishpadidem

    The unknown member maps to the missing state when you build a mining structure based on an OLAP cube and this is usually the behavior you want. Are you looking for a different behavior

  • joshlarsen

    Hi, Raman, thanks a lot.

  • LaurieCSI

    Yes the unknown member is added automatically during dimension processing. You can change the UnknownMember property of a dimension to None in BI Dev Studio by bringing up the dimension properties and expanding "Advanced" in the property pane. You'll need to reprocess the dimension and affected cubes.

  • korggy

    Hi, Raman, thanks a lot. I have followed the steps you guided, but the unknown member is still shown in the cube content though

    1. set the property of unknown member to be none.

    2. reprocess the cube.

    But when I browse the cube, the unknown member is still shown in the cube though.

    Thank you very much for your further advices.



  • Kumar Puran

    Hi, Raman, thanks a lot.

    But my question is the unknown member in cubes is just added by the system automatically Since the unknown member is actually not existing in the original data sources Is there any way to delete the unknown member in cubes before data mining Thanks a lot for guidance.



  • Rhapsy

    The property change should work. Did you re-process the dimension as well The property change may not be a "structural change" that forces dimension re-processing when the cube is reprocessed.

  • How can we deal with unknown member in cubes for data mining?
Answer this question