Rank specific product or company without a dimension table

[tanykozel]

Could you pls help me with next issues

1.  Is it possible to show the rank of one specific product/Company without dimension in table?

2.  How to show the   name of Company/product with specific rank , for ex. to show company with rank=2.

unfortunately I did't found similar problem anywhere and hope you can help on this

Thank you in advance