Add 'filtered' dimensionality to your StoreSales metric on the Store column. This will add up sales for all the departments on the report, as against all the departments in all the stores.
Based on your example you specified, your ID and Desc are not 1-to-1 related. Also, you did mentioned "I would like to have all the id's group under the same descriptive name." If this is what you want to do, then you might want to create two attributes:
1. Product
2. Product Color...
According to best practices, ID & Desc columns are 1-to-1 mapping to each other. If you group by ID or Desc does not really matter as long as you are displaying the Desc. Grouping by ID is the best approach for performance reasons.
My question is, Is there a specific reason why you want to...
This is easy...
Do you have a Month Number column in the Database? If yes, then what you need to add a logical column 'Month Number' mapping to the column mentioned above. The is in Admin Tool, edit the logical column Month Name and set the sorting according to the Month Number column. Whenever...
There are a lot of offsrpings from Microstrategy in the last couple of years. Many senior people leaving MSTR have formed specialized, niche, consulting practices doing Microstrategy consulting from a BI implementation prespective. You might wanna look at some of these firms in order to get...
This could occur because of the data type not being supported by the ODBC driver. Try to change the data type of the filed you are doing a sum on to FLOAT instead of INT or NUMBER. Re-import or refresh the physical layer, restart the Analytics Service and run the query again.
Hope this helps...
Ofcourse it is possible. We have done it at our implementation. What siebel recommends is that you create a copy of the existing Mappings and make changes in the copy instead of changing the original mappings. This is obviously to have a smooth upgrades to the future versions.
Hope this helps
Project Merge Wizard is basically an advanced version of the object manager. I have used object manager quite a few times and one condition that existed was that the two projects that you are trying to merge or move objects between has to be duplicates of each other in other words it should have...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.